How do I search a form by numbers that I want to ask a person to enter? The form I'm working with is "HMBA logB Query". I'm pretty confused as to the features of forms as well, are there any good online reading material?
Many of us can't or won't download files. You might want to search the web for Access tutorial. Crystal Long has some great videos and practically every question you might ask has been answered somewhere.
if you have a combo box with a query thay looks up the data eg addressID, first and last name then on after update use
Private Sub Combo98_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[AddressID] = " & Str(Nz(Me![Combo98], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.