clear form after add entry button is clicked

B

Bonni Wilbourne

I have an add entry button that will add the entry but it does not clear the
information from the form. How do I get the form to clear after entry?
 
M

Maarkr

If you're saying that you have a field that you made to enter information,
then click on a button to enter it on your form, you can just add something
like '[text01]=null ' in your on_Click event to clear it out. You may need
to explain more if that is not the case.
 
J

John W. Vinson

I have an add entry button that will add the entry but it does not clear the
information from the form. How do I get the form to clear after entry?
Click to expand...

How are you actually doing the entry? By typing into a form, or in code from
the button? What's the Recordsource of the form: is it bound (to a table or
query) or unbound? More info please!
 
T

Tony Toews [MVP]

Bonni Wilbourne said:
I have an add entry button that will add the entry but it does not clear the
information from the form. How do I get the form to clear after entry?
Click to expand...

If you are using a standard bound form then put
DoCmd.GoToRecord , , acNewRec
in the code behind that button.

BTW what is the code you are using to do the add entry?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top