No Combo Box

[Brenda from Michigan]

User has Access 2002 SP3. She is designing a form using a Combo Box to type
in an account number. When a valid account number is typed, it automatically
fills in other data in the form such as company name, address, etc. She
wants to know what tool can be used other than a Combo Box or List Box that
will do the same thing without using a Combo/List Box. She does not want a
drop-down showing every available account number. Can anyone help? Thank
you.

 

[Bill - ESAI]

why wouldn't she use a text box??

Bill

 

[Brenda from Michigan]

This makes sense to my user and she's going to try it out. Thanks so much
for the speedy responses. They are appreciated.

- Brenda

 

[Brenda from Michigan]

As a follow-up, the user also wants to know "where I can get code that will
give me an error msg when someone types in incorrect data into this TextBox."
Can you help with that also?