Adding Records Only On Button Click?

[Ksan]

Adding Records Only On Button Click?

I am building a database with a single table of records. I have created a form to allow new entries to be made to the table in a user-friendly way.

The problem I’m stuck with is how do I restrict the addition of new records on the form? I want the new record to only be added to the table upon the click of a button, but at present if I tab through, or exit the form the record is saved anyway.

Not all fields on the form are required input so I’m thinking that validation of every field is not the way to go.

I only ever want the record to be saved if a user clicks on a button and under no other circumstance.

I've been trawling through the posts back to about page 15 so any help would be appreciated.

Ksan

 

[Ksan]

Nice one. Fingers crossed I should be able to make a start from that.

Many thanks

Ksan

 

[AngelsGuardian]

You could also make a form unbounded and do a "INSERT INTO..." statement

 

[Cosmos75]

I've got a sample here that deals with adding records only when the ADD button is pressed. It also demonstrates how to deal with confirming edits to controls (bound to a field) and the entire record.

Link to sample is at the end of the article.