i have the text box and the subform and all the records
I would use a combo to select city rather than typing (fumble fingers
typing) to be used as criteria in a query. Have event requery after
selection.

--
Build a little, test a little.


"Srenfro" wrote:

Hello I am trying to creat a search option in my database where when I want
to find customers by city all i have to do is type in the city in the text
box and search and all the results show up in the bottom datasheet subform so
far i have the text box and the subform and all the records but when i try to
do a search it acts like i hit tab and just goes to the record right under or
next to the record and it also show all my records not the ones i was trying
to search. is there a way i can get this text box to search and only bring
the results i want to show up in the subform thank you in advance