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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting combo box drop-down list 1
Retain combo box order 1
Reset combo box on unbound form 5
Combo Box On Click 6
Update Combo Box 4
Run a query after selecting from combo box 3
Combo Box help 0
Need combo box to refresh when moving to new record 2017 1

Back
Top