Help...How to reset combo boxes???

[Guest_imported]

I created a form with 2 combo boxes that call up a report from a query. How do I reset the combo boxes automatically after a selection is made without closing and opening the form again...??

Thank you...

 

[dallison]

I'm not sure what you might be trying to accomplish, but I created a form with a combo box (Combo0) and a button (Command0). In the Command0_Click event, for the button, I placed the following:

Private Sub Command0_Click()
  'Opens the report
  DoCmd.OpenReport "rptReport", acViewPreview
  'Clears the entry in the Combo Box
  Forms!frmFormName!Combo0 = ""
End Sub

Hope this helps...

 

[LonnieJohnson]

In the second combo box's AfterUpdate event you can do this:

ComboBox = ""
ComboBox = ""

This is simular to the above. ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[LonnieJohnson]

That should be

ComboBox1 = ""
ComboBox2 = "" ljprodev@yahoo.com
Professional Development
MS Access Applications