helpneeded123
Technical User
i have a form displaying records for a certain key value from a table. now every time i make some changes and move to the next record the changed record gets saved in the table. Is there a way to stop this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
how to move to next record without saving
- Thread starter helpneeded123
- Start date
- Status
FancyPrairie
Programmer
On the BeforeUpdate event of the form do this:
Sub Form_BeforeUpdate(Cancel As Integer)
If (Me.Dirty) then Me.Undo
End Sub
Sub Form_BeforeUpdate(Cancel As Integer)
If (Me.Dirty) then Me.Undo
End Sub
Guest_imported
New member
- Jan 1, 1970
- 0
For forms, you can use the BeforeUpdate event to cancel updating of a record before moving to another record. See online help.
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
- Locked
- Question