Macro to clear form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MsNadi - 16 Mar 2006 18:25 GMT

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? :)

Reply to this Message

Klatuu - 16 Mar 2006 22:19 GMT

The command button would be better.
What do you mean by clear a form?

> 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
[quoted text clipped - 5 lines]
>
> Either way - how do I clear a form? :)

Reply to this Message

Ed Robichaud - 17 Mar 2006 15:28 GMT

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

> I've created a form that will run a query based on the selections chosen
> in
[quoted text clipped - 9 lines]
>
> Either way - how do I clear a form? :)

Reply to this Message