Combo Box reset

[Phil]

Hi,
I have a combo box that gets its data from a table. On my form the combo
box shows a records and if the user types something in the box that isn't in
the table I want to display my own message and have the combo box returned to
the value that was there before the user changed it. How do I do this and
not get the Access message? The "not in list" is set.

Thanks in advance.....

 

[Dale Fye]

Phil,

Use the NotInList event of the combo box. You can display your own message,
and then return control to the combo box.

Dale