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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

moving to next record without saving

Status
Not open for further replies.
helpneeded123

helpneeded123

Technical User
Joined
Jun 21, 2006
Messages
2
Location
IN
how to move to the next record without saving it
if I set cancel = true in before update the change is not saved in the table but the cursor doesnt move from the record and stays in the old record
 
Sort by date Sort by votes
I going nuts! Thought I answered this (this happend on another post too, where I'm sure I answered it).

Anyway, try this on the BeforeUpdate event

If (Me.Dirty) then Me.Undo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
1K
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question Question
Open filtered for and set cursor at particular record
Replies
1
Views
820
Moss100
Moss100
renigar
  • Locked
  • Question Question
Code to write file path to field always writes to 1st record
Replies
5
Views
1K
dhookom
dhookom
hermanlaksko
  • Locked
  • Question Question
Convert PDF file to text
Replies
6
Views
878
hermanlaksko
hermanlaksko
Moss100
  • Locked
  • Question Question
Vba adding record to table when field is integer
Replies
8
Views
871
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top