Save record

[Sam]

Hi

is it possible to not save a record when the user enter
the information in a form, until he or she click on Save
buttom, because there is a lot of validation I have to
do, so I prefere to control all the save action from a
bottom


Thanks

 

[Roger Carlson]

The easiest way to do this is with an unbound form. That is all neither the
form, nor any of the controls are bound to an underlying table or query.
Once all of the validation is done, you write the data to a table through
SQL statement or VBA code. On my website (see sig below) are a couple of
small sample databases which illustrate how this can be done. Look for:
"Unbound.mdb" or "UnboundSQL.mdb".

 

[Chris]

Thanks Kevin and Roger

-----Original Message-----
Sam,

In a word, Yes! Make your form an unbound form, then put a
button on your form and in the onclick event, create a
subroutine that performs your validation and then saves
the information using an append query.

Alternatively, you can, still using an unbound form, put
validation into each field or controls Beforeupdate event
to do the validation.

If you need more help, post back and we'll see what we can
do. Provide more details and we can provide more help!

Kevin
.