Jeffers
09-24-2000, 02:50 AM
Any suggestions on how to confirm an added/updated record on a form before it updates the table?
[This message has been edited by Jeffers (edited 09-24-2000).]
Jack Cowley
09-24-2000, 08:59 AM
Search help for NewRecord property and the Dirty property. Using these properties should tell you what you want to know....
HTH,
Jack
Pat Hartman
09-24-2000, 06:03 PM
Put your code in the form's BeforeUpdate event. That event is the last one executed before the record is actually added/updated. If the user chooses to cancel the update operation, you can just set Cancel to true and exit the event.