Tab order on forms PLEASE HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!)
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab order incorrect 3
Change tab order in a tab control 3
Removing a tab order for a control in a form 3
HELP WITH TAB CONTROL - HIDING FIELDS 7
Tabs to label rather than to value 5
Arrange fields on a form 3
I am having difficulty controlling my tabs. 1
Delete subforms from tab order 3

Back
Top