Macro initiated by Command Button

[TomC]

I want to place two different Command Buttons on my data entry form which has
a subform and which has a combo box to retrieve records to the form. If the
record to be keyed is not in the file, I would like a "NEW RECORD" button to
initate a macro to go to the end of file for keying the new record. I would
also like a "CANCEL" button to cancel the keying of the new record. Is the
macro CancelEvent good to use with the CANCEL button? And is there any macro
which would get me to the end of file for the NEW RECORD button??
Thanks for any help.

 

[Steve Schapel]

Tom,

For the new record, use the GoToRecord/New action. For the Cancel, it
depends a bit on what you really intend, but probably the
RunCommand/Undo action is what you need.

 

[TomC]

THanks Steve. It looks like it is working perfectly. I have another macro
question, but I'll try to figure it out myself before bothering anyone.
Thanks again.