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.

 

[ruralguy via AccessMonster.com]

Just use an unbound TextBox. Use the code from the ComboBox AfterUpdate event
in the AfterUpdate event of the TextBox.

 

[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?

 

[ruralguy via AccessMonster.com]

The code for the Lookup ComboBox AfterUpdate event has an If Found section.
Just create a Else for that section.

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?

Just use an unbound TextBox. Use the code from the ComboBox AfterUpdate event
in the AfterUpdate event of the TextBox.

[quoted text clipped - 6 lines]