Prevent manual input in drop down field

[luscioussarita]

Hi Everyone,

I am kind of stuck. Usually someone else has gone through my suffering on
the discussion group or attempted some coding to match. I have found none.
Here is my dilemma.

I have created combo boxes which related to several different data tables
within my database. They work great on the forms no issues. The drop down
menus have one flaw. Anyone can manually enter data on it but an error
message pops up telling the user to select from the list. The drop down
menu's are limit to the list in the table. Here are my questions:

1) How do I prevent the user from entering anything within that drop down
menu field?

2) How do I kill that error msg screen?

Any thoughts!!!!

 

[Klatuu]

You can only prevent input in a combo by locking or disabling it. Neither
will do, because even then you can't select from the drop down. You can
make the message go away. But, it may be that a list box would be more what
you want. You can ony select a list box by clicking a selection

 

[ruralguy via AccessMonster.com]

In addition to Klatuu's suggestion, you could also set Limit To List to YES
and put your own message, or none in the OnNotInList event including a Me.
ComboBoxName.UnDo to clear any entry; using your ComboBoxName of course.