Combo Box reset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
Phil,

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

Dale
 
Back
Top