Skip patterns

  • Thread starter Thread starter Tracy
  • Start date Start date
T

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.
 
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
 
Back
Top