Clear selected value in combo box

[bbrazeau]

I have a combo box on a form. The user selects a value then presses a command button and opens a form. When the user closes the form returning to the 1st form again, I'd like the combo box to be clear again.


I've tried putting me.combobox=null in just about every event the main form has but nothing works. Is there a way to clear this without putting me.combobox=null in the On Click event of the command button? I have quite a few command buttons on that form and don't want to have to put the code in all of them if I don't have to. Thank You.

[June7]

Why would clear code need to be behind other buttons? Do they also have code that uses the value in combobox?

You could try form LostFocus event.

[chodges]

For a cbobox, I've used:
me.cboname = ""

You can put it in the button that opens the other form.

if you want to clear the combo box entirely, then,
me.cboname.rowsource = ""
me.cboname.requery

The listbox is different....

Cindy

[June7]

I set listboxes and comboboxes Value property to Null throughout my project.

[bbrazeau]

Yes, there are other buttons on the form that use the value in the combobox. I have put the code to clear the combobox in the opened forms on close event. This seems to work. The reason I didn't want to put the the code in the on click event of the button is: I was using the value as well as others on the form to set values in the form opened with the on load event

Me.Customer = Forms!frmMain!cboCustomer
Me.Part = Forms!frmMain!cboPart

Example: the user selects a Customer and a part, and opens a form that creates a quote to that customer for that part.

[June7]

"This seems to work."
Thread is marked as solved.
Your issue is resolved?

[balajigade]

You can embed a macro in the event procedure of the 'return' button configuring 'setvalue' property of the combobox to null and 'openform' property next.