Once again thank you for your previous help, I wonder if I might ask another question. How do I include a button that will rest the form? I want to be able to run another search without closing the results of the first if possible. Many thanks Rob
Reply from Richard Rost:
Do you mean RESET the form? You could close and reopen the form with two lines of code:
docmd.close ... docmd.open ...
Or you could individually set the values to blank:
firstname="" lastname="" etc.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Another Access Seminar?.