I'm quite new at Access, so please bear with me.
I would like to create a form that adds a record to a table, but not until the user clicks a button. The buttons will be "Save and Close", "Save and Add Another", or "Close and Discard Changes". If the user clicks either of the Save options, the record should be added as the last record in the table; the discard button puts nothing in the table.
What VBA code do I need to have the new record added?
I would like to create a form that adds a record to a table, but not until the user clicks a button. The buttons will be "Save and Close", "Save and Add Another", or "Close and Discard Changes". If the user clicks either of the Save options, the record should be added as the last record in the table; the discard button puts nothing in the table.
What VBA code do I need to have the new record added?