Textbox with not in list option

[Russ via AccessMonster.com]

How can I Make a textbox with not in list option?
I have a part number field on my order form that when they enter the part
number, I need it to verify the number is in the tblproduct.

Can I do this without a cbobox?

 

[Al Camp]

Russ,
Yes, you can, but why would you want to?

You could use the text control BeforeUpdate event to do a Dlookup against
your table, and post a message that it doesn't exist, and cancel/undo the
entry.

But... the combo NotInList does that for you automagically, as well as
assisting the user (through auto correct) in the data entry process.

 

[fredg]

How can I Make a textbox with not in list option?
I have a part number field on my order form that when they enter the part
number, I need it to verify the number is in the tblproduct.

Can I do this without a cbobox?

What do you have against combo boxes?
That's the correct control to use.
Set it's LimitToList property to Yes, and it's AutoExpand property to
Yes. Bind the control to the PartNumber field. Only numbers in the
list can be entered.

 

[Russ via AccessMonster.com]

I am using the field for a bar code scanner input, so I did not want the drop
down box but needed to verify the data exist. Any other ideas would be
greatly appreciated!

 

[Russ via AccessMonster.com]

I am using the field for a bar code scanner input, so I did not want the drop
down box but needed to verify the data exist. Is there any way to hide the
arrow on the right hand sidee and disable the dropdown so they would not know
it is a drop down box? Any other ideas would be greatly appreciated!

 

[Al Camp]

I did give a solution...

You could use the text control BeforeUpdate event to do a Dlookup against
your table, and post a message that it doesn't exist, and cancel/undo the
entry.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Russ,
Yes, you can, but why would you want to?

You could use the text control BeforeUpdate event to do a Dlookup
against your table, and post a message that it doesn't exist, and
cancel/undo the entry.

But... the combo NotInList does that for you automagically, as well as
assisting the user (through auto correct) in the data entry process.