I have a form that has a combo box users select from, which then populates fields on the form.
It's holding the data after existing the form. How do I make it so that the form is cleared each time a user goes to it?
Thanks.
I have a form that has a combo box users select from, which then populates fields on the form.
It's holding the data after existing the form. How do I make it so that the form is cleared each time a user goes to it?
Thanks.
Put a command button on your form. In the on click event type this code:
On the face of the command button, type Clear Combo Box.Code:me.comboboxname.value = "" me.requery
Alan