See:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

The article explains how to jump to the record you want by selecting from a
drop-down list. You can use the same code with a text box if you prefer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Grimell" wrote in message
...
I have a very simple dbase, only one table. I want my data entry folks to
be
able to enter the primary key, Account Number, and have all the customer
info
come up in the form. Meaning I enter in the account number on the form
and
all the other info: name, address, phone Autofill in the form. Do I need
to
use a macro or code it in VB?