The form has nothing to do with saving the record. The form is based on a
query or a table. The fields on the form are bound to that source. So when
entering data in a certain field the form(read "record") becomes dirty. When
the users reaches the last field and exits on that one the record is saved
(meaning the form, record is no longer dirty). This is standard
functionality. If you want to not save the record you'd have to base the form
on something else then the table or query. In some cases people use tmp
tables to write the records to and when closing the form the user is being
asked if he/she wants to save the records. When confirmed an append query
adds the records to the original table. But be aware that temp tables need to
be emptied when done and can take up very much space in your database.
Recommende practice is to place tmp-tables outside the original MDB.
hth
