clear combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form with several combo boxes . Users can select from these combo
boxes and return a recordset that meets their criteria. On this form I have
a button which allows users to create a new search. When clicking this
button, I would like the previous criteria to disappear. I see from these
forums that Me.comboname=null would be the VBA syntax, but I have already
attached a macro to this button and am not familiar with VBA. Are there any
actions in a macro that would accomplish this?
 
In a macro, you can use the SetValue method. Enter a reference to your form's
combobox (Forms!MyForm!MyComboBox) in the Item field and enter "Null" as the
expression.

HTH,
Barry
 
Back
Top