Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to search values on a form

Status
Not open for further replies.

ambersd12

Technical User
May 25, 2011
12
US
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.

Duane
Hook'D on Access
MS Access MVP
 
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

Never give up never give in.

There are no short cuts to anything worth doing :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top