control recording saving

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

904allen - 18 Jan 2008 01:43 GMT

I designing a form the feilds are bound. the form will be used by other
workers i want the form to update records using a update button but if the
user enters data and then decides that they don't want to update the
information. hqw can i prevent the update of the information entered on the
form when the user closes the form using the close button

Reply to this Message

Larry Linson - 18 Jan 2008 02:04 GMT

> I designing a form the feilds are bound. the form will
> be used by other workers i want the form to update
[quoted text clipped - 3 lines]
> mation entered on the form when the user closes the
> form using the close button.

The Command Button Wizard will give you the option to save the current
record, so your "Update" button will not require VBA code nor Access macros.

You are correct, that saving updates is automatic, on closing the form, on
moving to a different record, on taking explicit action to save, or on
moving from the main form into a subform control. However, there is a
BeforeUpdate event in which you can insert an Access macro or VBA code to
cancel the update... depending on your needs, you can either clear the
updates in the form, or you can just return to the form (this is often done
when you include code to validate the values entered, if one or more values
fail validation).

Larry Linson
Microsoft Access MVP

Reply to this Message