Question Locked

Question

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can i search data on a Subform using command button and Combo box on a main form in Ms Access

2 replies

by john.a.wills

Private Sub SeekByID_AfterUpdate()
Dim rs As Object
Me.Filter = ""
Set rs = Me.Recordset.Clone
rs.findfirst "[ID]=" & Str(Me.SeekByID)
Me.Bookmark = rs.Bookmark
End Sub
I am assuming that the combo box is in the main form and the items with key ID are in the subform.

This discussion is closed to new replies.