Save and close

[brobb56]

I have a form that I want a button that will save the form and close the form. Can someone help.

[goodguy]

In design mode, make sure the 'Use Control Wizards' option is selected.
Then, when you create a button, the wizard will guide you with a vast choice of options.

[jo15765]

Are you wanting to save the actual form, or save the data that was just entered on the form?

If you want to save the data that was just entered on the form, you can create a button, and choose Record Operations ---> Save Record, and once that button is pressed, all data that is entered on the form, will be saved to the table.

And if you add this line of code into the same onclick() event of your save button you can save and close:

DoCmd.Close acForm, "FormName"

[brobb56]

In access 2010 there is no 'Use Control Wizards' option unless I am looking in the wrong place.

[goodguy]

Open the form in Design View and then under Design Ribbon, look for it.