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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Close form without saving data

Status
Not open for further replies.
rphbrew

rphbrew

Technical User
Joined
Nov 30, 2002
Messages
40
Location
US
I am using the following code

DoCmd.CLOSE acForm, "FormName", acSaveNo

I have this on a cancel request button. However the data entered gets saved.

 
Sort by date Sort by votes
Hi!

In the cancel button add a Me.Undo and then close.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
Worked like a charm

thanks

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question Question
Form Data Not Updating
Replies
6
Views
1K
dhookom
dhookom
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question Question
Forcing Form Updates
Replies
2
Views
829
TrekBiker
TrekBiker
rdpress
  • Locked
  • Article Article
Determine if Close Button is Used to Close Form
Replies
3
Views
437
Andrzejek
Andrzejek
renigar
  • Locked
  • Question Question
Trying to add hyperlinks to pdfs through form entry
Replies
0
Views
718
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top