It sounds as if you are doing something like this:
Append blank
[fill in form]
[check for errors]
replace x with m.x, ...
If this is so, I would recommend that you have the user fill in the form using memory variables of the same name as the database fields. Do all of your validations against these fields. When you are truly ready to put the record in the database, peroform an INSERT INTO [databasename] FROM MEMVAR. This is more efficient, gets rid of the kinds of problems you are discussing, and ensures that there are no orphan records.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only