text box search form

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

Guest

hello,
i want to bring up a simple for that has one text box that says "enter
customer last name". when i enter the name and hit enter i want my customers
form to open to that customers record. I can't seem to figure this out. I'm
new to access but i can't find instruction on how to do this anywhere.
any help will be greatly appreciated
mcrafters
 
hello,
i want to bring up a simple for that has one text box that says "enter
customer last name". when i enter the name and hit enter i want my customers
form to open to that customers record. I can't seem to figure this out. I'm
new to access but i can't find instruction on how to do this anywhere.
any help will be greatly appreciated
mcrafters
Click to expand...

You can actually do better than that: if someone were to enter
"Vincent" looking for me, or "McCrafters" looking for you, they'd miss
us.

Instead, use the Combo Box toolbox wizard to create a new unbound
Combo Box on the form. This will provide a list of the names actually
in the table. Choose the option "Use this combo to find a record on
the form". If the wizard doesn't work or gives you the wrong results,
post back - it takes a little bit of VBA code but it's easy.

John W. Vinson[MVP]
 
Our customer they want text box to enter search for Last name. How can we
code in VBA...Thanks
 
I am in a similar situation. I have the combo box working but what do I do
next to have the record show up on the form?
 
Back
Top