Refresh Form

[84hickman]

I have a form that has four listboxes and a command button. The command button runs a macro that starts a query using the choices of the 4 listboxes as parameters. If nothing is selected in a certain listbox then records with any value in that related field are returned. This all is working great.

What I would like to do is clear the user's choices after running the query... or upon clicking a new command button.

This seems like it should be simple to do... but I just can't seem to get it to work.



Thank you!!​

 

[jackd]

Watch this video tutorial and see how he clears/resets the form.
http://www.datapigtechnologies.com/flashfiles/searchform.html

 

[84hickman]

PERFECT!!

That is just what I was looking for. Thanks so much Jack!

 

[84hickman]

Actually... I lied.

It looks like it clears the choices on the form but when I try to run the query a second time after clearing the previous choices I get an error message.

"The expression is typed incorrectly, or it is too complex to be evaluated....."

 

[jackd]

Can you post the code/SQL involved?
You could try a Debug.print statement or statements to see what is being done.