Prevent Adding Record Tabbing Thru Fields

[Barkster]

How do I prevent the adding of records when tabbing through all the
fields on a form? I want to force them to push to insert button. Do I
have to hand code my sql to do this or is there a setting I can change
to prevent this. Thanks

 

[Jeff Boyce]

In the form's properties, find the one that deals with "cycling". Set it to
"Current Record". That way, when someone tabs "out" of the "last" control
on the form, the focus goes back to the "first" control on the form. Since
you don't leave the form, you don't save the record.

Now add your <Insert> command button.

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

is there a setting I can change
to prevent this

Set the Form's Cycle property to "Same Record".

Tabbing past the last field in tab order will put you back onto the
first field of the same record.

John W. Vinson[MVP]

 

[Barkster]

Exactly what I needed, saved a few hours of writing huge sql
statements. Thanks!