Access: How can I find a record using a Text Box to enter the sea.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm kinda new on Access and I'm trying to use a text box in a form to search
for a record... (Just placing the searched data on a text box and hit enter
and get the searched data)

Please help!
 
I'm kinda new on Access and I'm trying to use a text box in a form to search
for a record... (Just placing the searched data on a text box and hit enter
and get the searched data)

Please help!
Click to expand...

A bit more information would have been useful, however if you are
searching a text field, try something like this as a very basic
filter.

Code the AfterUpdate event of an unbound control:

Me.Filter = "[LastName] Like '*" & [ControlName] & "*'"
Me.FilterOn = True

Change [LastName] to whatever the actual field to be searched is.
 
Back
Top