ComboBox Back To Blank

[Jani]

The data on a form is put into a work table, once the data is entered, the
data is appended to a permanent table, the work table is deleted and the form
is refreshed ready for the next job. A combo box pulls jobs from a form and
then inserts data automatically into other fields. My problem is that after
the data is moved, form refreshed, etc. the job stays in the combo box. I
need it to be blank so that the same job is not used again. Tried refreshing
and some other things but can't get it to work. Any help, as always, is so
very much appreciated! Jani

 

[Jeff Boyce]

Jani

In the code you use to do all that moving around, do you have a line
something like:

Me!YourComboBox = Null

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jani]

Thank you so much - works perfectly!!! jms

Jani

In the code you use to do all that moving around, do you have a line
something like:

Me!YourComboBox = Null

Regards

Jeff Boyce
Microsoft Office/Access MVP