Tab Order - a little unorthodox

[lmnop7854]

I have a form set up, with the normal default tab order set as needed. It is a questionnaire form, so the user would tab through the questions, and it doesn't matter if some are blank. However, I have 3 questions on the form that, dependent on the Yes/No answer, should tab to different fields. For example, if the answer is yes, the tab moves to the next field. However, if the answer is no, the tab moves to a new section, skipping the rest of the questions in the section. Any ideas?

Lisa

 

[DonK]

Use:
Me!TargetFieldName.SetFocus

 

[trucktime]

Tab Order

In the AfterUpdate of the Yes/No field put something like this:

If YesorNoField = True Then
Me.Field1.SetFocus
Else
Me.Field2.SetFocus
End If

 

[lmnop7854]

Thanks, trucktime!!! That worked like a dream!!

Lisa

 

[trucktime]

Great

You're welcome, always glad to help.