Skip patterns

[Tracy]

Hi,

How do you write code to skip past a few fields if someone selects a certain
response to a field (combo box). For example, if [Mechanism] <> 1 then I want
the form to skip to the field, [Intent]. I am guessing the code will include
the SetFocus statement? Yet I am not sure how to write it. Thanks.

 

[Klatuu]

Use the After Update event of the combo box.

Private Sub Mechanism_AfterUpdate()
If Me.Mechanism <> 1 Then
Me.Intent.SetFocus
End If
End Sub