Not adding Data Automatically

[vertue]

Hi I am posting this to show how new I am at using Access.
I am building my first make believe database for practise. My problem is this.

When I open a form to enter data. I have it going to a new record. I have two problems with this that could be mended with one answer.

I do not want the new data to be added to the database until a button is pushed.

I hope that makes sense and you can steer me in the right direction remembering how new at this I am.

Thanks in advance for the answers and hello everyone.

 

[llkhoutx]

Because your data is (apparently) bound to a table, input goes into the table.

Use the following instruction triggered by a button or other event to delete the current record contents:

Sendkeys "{ESC}{ESC}"

Note that

Sendkeys "{ESC}"

empties the object having focus.

This should eliminate data which you have entered in a current new record.

Another method is to use an unbound form which saves data to a table on an event of your choice. This, of course, requires code; the more complex the form, the more the code.

Note tha when Me.Dirty=True, data has been stored in a form.

Among other things, Access requires a whole new mind set. Think of events and objects.

This is covers more than you asked, but it should give you some other ideas.

 

[llkhoutx]

Because your data is (apparently) bound to a table, input goes into the table.

Use the following instruction triggered by a button or other event to delete the current record contents:

Sendkeys "{ESC}{ESC}"

Note that

Sendkeys "{ESC}"

empties the object having focus.

This should eliminate data which you have entered in a current new record.

Another method is to use an unbound form which saves data to a table on an event of your choice. This, of course, requires code; the more complex the form, the more the code.

Note tha when Me.Dirty=True, data has been stored in a form.

Among other things, Access requires a whole new mind set. Think of events and objects.

This is covers more than you asked, but it should give you some other ideas.