Stop the tabbing

[steve711]

I have a form open in ADD and have several text boxes on this form. I also have a SAVE cmdButton that when clicked basically closes the form. However, when the user continues to tab after the last tab item (the SAVE button) it then blanks the form (saving it to my table of course) and it is now ready for the next ADD.

How can I stop this from happening? I would like it to tab back to the first textbox without clearing out the form and just loop like this until they finally get around to clicking the SAVE button.

 

[adam_fleck]

Cycle?

I'm not sure about this, but, in Design view, you could try calling up the Form's property box, clicking on the "Other" tab, and setting the "Cycle" option to "Current Record".

When the "Cycle" option is "Current Record", tabbing from the last field on the form moves to the first field without changing the record that is current.

When the "Cycle" is set to any of the other values, tabbing from the last field moves to the first field on the next record.

 

[steve711]

Well that did the trick, thank you very much.