Re: No Combo Box

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" wrote:

> Just use an unbound TextBox. Use the code from the ComboBox AfterUpdate
event
> in the AfterUpdate event of the TextBox.
> 
> Brenda from Michigan wrote:
> >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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
> Please post back to this forum so all may benefit.
> 
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200808/1
> 
>