Data Entry Form Question

[magster06]

First of all, sorry for all of the questions, I am a newbie at Access.

Is there a way to enter data into a form and this data not be saved into a table until a user clicks a command button to save the info?

The reason I ask is because I have a form where a primary key is auto generated and everytime the form is opened a new identifier is created. If the user decides not to create a record at that time, then when they go to close the form it saves the identifier.

Anyway to prevent this from happening?

 

[Alansidman]

You could use an unbound form and have an update query executed when you press a command button. Here is a tutorial on how this would work.

http://www.datapigtechnologies.com/flashfiles/addformrecordsnocode.html

 

[magster06]

I'll give it a try, thanks!

UPDATE:
I gave up on the idea due to the fact that I have one form entering data into 2 tables and it seems like I would have to change too much. I will give it a try on another project.

I ended up placing a "Cancel" button to undo any entries. I am not sure if this would be the proper way, but it is the only simple way that I know.