how to enter a new record on a form

[seangibson]

I have a form for entering data into a tablel. I want to have a command button which enters teh current data into the table and then makes the form blank, ready to enter and additional record. How do I do this? (I'm sure it's simple and I've done it before but I can't quite remember how to do it).

[Trees]

Yes, Sean it is very simple.

From the "Toolbox" select the Command Button and place where you want on the form. Once you do so, the Command Button wizard will open allowing you to select what you want the button to do. In your case choose Record Operations under Categories and then Add New Record under Actions. Click
Next and decide how you want your Command Button to look - Text or Picture. Click Next again, and name your button. Click Finish. If you choose Text, then you can change the text in the box after you click Finish from the
Properties box for the Command Button.

Hope this helps.

[seangibson]

Great. I had somehow lost the event procedure and was trying to reinstate it. It was much simpler to start over. Thank you.