Macro to clear form

M

MsNadi

I've created a form that will run a query based on the selections chosen in
the form (QBF). However, at the end of the macro, I would like to the form
to clear to prevent a loop. How do I do this?

Currently the Macro is set up to run the query based on the selection of an
option box (hence, the loop). Would it make more sense to have the event be
generated off of a 'command button' after making selections?

Either way - how do I clear a form? :)
 
E

Ed Robichaud

If you want to remove the values in unbound controls on your fom, just set
them to null or "" after you're done using them.
Me!myContol = ""

-Ed
 
Top