Stopping Automatic Add at end of form

  • Thread starter Thread starter David Ross
  • Start date Start date
D

David Ross

This is my first time with Access so please be gentle.

I have a situation I can't figure out.

I have a Membership data base and when adding a new member via a simple
form I do not want the record added after the last field is entered. I
want there to be a positive click on an "Add" button required. I have a
flag set when this button is clicked but I can't figure out where to
test it and what to do when it is tested. I want the user to cycle
through the fields until they click "Add" or click my "Never Mind" button.

I tried putting a cancel event in the OnUpdate event but that put me in
a state where I could never exit the form. UnDo will wipe out the
entries made so far. Is there a way to deal with this?

FYI, this is NOT a data entry type of application. There will be maybe
one or two new members a month. And I'd rather them (and so would they)
have to do a positive click to put in someone new rather than have
Access just add them as they cycle through the fields.
 
I want the user to cycle
through the fields until they click "Add" or click my "Never Mind" button.
Click to expand...

Set the Form's Cycle property to "Current Record", and turn off its
navigation buttons.

John W. Vinson[MVP]
 
Back
Top