Navigating - Skipping fields on form with Yes/No

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

Guest

Is there a way to skip a field when a yes/no box is checked?

If a YES is in field A, I want to next go to field D and continue my tab
order from there. If field A is not YES, then you go to field B.


Thanks
 
DonElston said:
Is there a way to skip a field when a yes/no box is checked?

If a YES is in field A, I want to next go to field D and continue my tab
order from there. If field A is not YES, then you go to field B.


Thanks
Click to expand...

You could try putting code in field B's Enter event that jumps to field D if
field A is True:

If Me.field_A = True Then
Me.field_D.SetFocus
End If

Another way to do it might be to disable or lock fields B and C (I assume
there is one) if field A is True, and enable them if field A is False. In
field A's AfterUpdate event:

Me.field_B.Enabled = Not Me.Field_A
Me.field_C.Enabled = Not Me.Field_A

Carl Rapson
 
Back
Top