Unbound combo box refresh

[Mary]

I am using an unbound form with several combo boxes that have macros attached
to the On Change Event to open reports based on the selection in the combo
box. When the report is closed, I would like the form to refresh so all
fields are blank. I've tried using me!controlname.requery in the After
Update event, but it's not clearing the combo box. Is this the right method?
Can someone help? Thanks, Mary

 

[Van T. Dinh]

Set the ComboBox value to Null.

 

[Mary]

Thanks for the tip, but unfortunately it didn't work. The value is still in
the combo box when the report closes. Anything else I can try?

 

[Douglas J. Steele]

In what event did you put the code to set the combo box to Null?

 

[Mary]

I had it in the After Update, but by moving it to the Lost Focus event, it
works. Thanks so much!