Add new record

[wgma]

I need to be able to add a new record by having users type in their information and when they click the Save button the data will be saved and all of the data entry fields on the screen will go back to their default value.

I have built a table that will hold the data. I have a form that is connected to the table automatically. I know that I will have to add some code behind the button but I am not sure what command to use.

I am using Access 2007 but saving it as 2003 database.

Thanks.

 

[RuralGuy]

Have you tried letting the Command Button Wizard create the save button for you?

 

[missinglinq]

when they click the Save button the data will be saved and all of the data entry fields on the screen will go back to their default value.

Actually, it sounds like the OP wants to Save the record then move to a new record, so all they have to do is place a button on the form, then when the Wizard comes up select

Record Operations - Add New Record

In the next screen choose "Text" and enter, as the caption, Save, then continue thru the wizard.

When the button is pressed, the record will, in fact, be saved, and Access will move to a new record, where the fields will revert to their default values, if any.

 

[wgma]

Thanks. I did that and it did not work so I started all over again and it is working now. I must have had something wrong in the code.

 

[missinglinq]

Glad you got it working!