View Full Version : Confirm Added Record/Update


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.