Combo Box Problem

[maxjake via AccessMonster.com]

Hi All

I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

I have tried Limit to list property to "yes" but when you try to add data to
the field the message is:-
Double - Click this field to add entry to the list.

Can I stop this?

Thanks Max

 

[ruralguy via AccessMonster.com]

That message is coming from *YOU*. You have code in the NotInList event of
the ComboBox. Remove the code for the standard message or replace it with
one of your own.

 

[maxjake via AccessMonster.com]

Thanks for your help, fixed the problem

That message is coming from *YOU*. You have code in the NotInList event of
the ComboBox. Remove the code for the standard message or replace it with
one of your own.

Hi All

[quoted text clipped - 10 lines]

Thanks Max