Tab order on forms PLEASE HELP!!!

A

ac512

Hello

Is there a way that you can ensure that the tab order on a form remains the
same, even if not all of the fields have been selected?
eg. I have a form which does not always require users to tab through all
fields/controls. If a user then selects the next record, the tab order
continues as per the previous page of the form, rather than starting again.
Is there a way that I can 'reset' the tab order when a user doesn't tab
through all fields/controls?
I hope that this makes sense, and that someone can help.

Thank you in advance
AC
 
G

Graham Mandeno

Hi AC

Use the "OnCurrent" property of the form to write an event procedure for the
Current event:

Private Sub Form_Current()
Me.[name of first control in the tab order].SetFocus
End Sub

The Current event occurs when you navigate from one record to another. this
procedure will execute when that event occurs. It simply sets the focus to
the first control (you must change the name to suit!)
 
A

ac512

Thanks very much Graham!
A very simple, yet very effective suggestion!

Much appreciated
AC

Graham Mandeno said:
Hi AC

Use the "OnCurrent" property of the form to write an event procedure for the
Current event:

Private Sub Form_Current()
Me.[name of first control in the tab order].SetFocus
End Sub

The Current event occurs when you navigate from one record to another. this
procedure will execute when that event occurs. It simply sets the focus to
the first control (you must change the name to suit!)
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

ac512 said:
Hello

Is there a way that you can ensure that the tab order on a form remains
the
same, even if not all of the fields have been selected?
eg. I have a form which does not always require users to tab through all
fields/controls. If a user then selects the next record, the tab order
continues as per the previous page of the form, rather than starting
again.
Is there a way that I can 'reset' the tab order when a user doesn't tab
through all fields/controls?
I hope that this makes sense, and that someone can help.

Thank you in advance
AC
Click to expand...
Click to expand...
 
Top