Tabbing through fields (1 Viewer)

[Little_Man22]

Tabbing through fields

What I need to do is have my tab settings such that if you select "no" from a combo box (yes/no) then the cursor automatically skips over the next couple of fields that do not apply. For instance if you select 'no' from the 'smoker' combobox the cursor will automatically skip over fields such as 'last used', 'amount used', etc. However, if you select 'yes' from the combobox the cursor will take you through all of the fields.

Is this possible?

 

[shacket]

In the AfterUpdate event of the combo box, set the focus on the control you want if the combo = no. (By the way, if it is a Yes/No choice, why are you using a combo box and not a Yes/No field?)

If Me.cboComboName = "No" Then Me.txtWhereYouWantToGo.SetFocus

 

[KeaganQuilty]

In the AfterUpdate of the combobox:

If Me.ComboBox= "No" Then
Me.FieldName.Visible = False
Else
Me.FieldName.visible = True
End If

Also put this in the OcCurrent Event of Form

Keagan Quilty
Kilbride, Newfoundland

 

[Little_Man22]

I was just using the yes/no scenario for simplicity when asking my question...thanks for your help though.