Filling a form

[Teleinternnor]

hi
is there anyway to temporarily store the information being entered into a form before actually writing it to a table. i want information to be added to the table only once the save button is pressed. i dont want the table to be used even as the scratch pad.
Thanks

 

[seth_belgium]

Sure.

Don't add a recordsource to your form.

Create a "ADD-query" (or is it an APPEND-query?) that will add all the values entered on the form to the table. Execute this query when the user presses the save-button (customized save button off course...).

Seth

 

[statsman]

Or you use Command Buttons on the form.

One would save the record, the other would clear the form.

---------------------------------------------------------------------------------------
Dart players always have a point.

 

[Teleinternnor]

Don't add a recordsource to your form.
Seth

but seth that way i wudnt be able to view the the previous enteries in the table and only use the form to add data to the table. any views?