If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Don't add record
Greetings-
This must be easy. I have an input form attached to a file. I have a command button labeled "Cancel" with an "on-click" event "DoCmd.Close" I enter some data, but decide not to add the record. I click the Cancel command button, but the messed up record is inserted into the file. What command or event do I use to close the form without adding a record? Thank-you, Mike |
#2
|
|||
|
|||
Don't add record
On Thu, 20 May 2010 15:34:08 -0400, "Mike from Moriches"
wrote: Greetings- This must be easy. I have an input form attached to a file. I have a command button labeled "Cancel" with an "on-click" event "DoCmd.Close" I enter some data, but decide not to add the record. I click the Cancel command button, but the messed up record is inserted into the file. What command or event do I use to close the form without adding a record? Thank-you, Mike Before the Close line, put a line Me.Undo if you want to prevent the record from being saved. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Don't add record
Mike from Moriches wrote:
Greetings- This must be easy. I have an input form attached to a file. I have a command button labeled "Cancel" with an "on-click" event "DoCmd.Close" I enter some data, but decide not to add the record. I click the Cancel command button, but the messed up record is inserted into the file. What command or event do I use to close the form without adding a record? Thank-you, Mike Me.Undo -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201005/1 |
Thread Tools | |
Display Modes | |
|
|