Skipping Certain fields in a form based on criteria

[kkhubb]

I have a form where the user chooses a response from a drop-down list. If the response is Items 1-6 I want them to tab to the next field and fill it in (This part works just fine). The problem comes in if the user chooses Item 7 from the drop-down. I want to skip the next three fields/tab stops and go to the fourth tab stop.



So I'd like it to do something like this: If Item = Item 7, then skip A, B, C and go to D (or set focus on D....etc)

Any help will be greatly appreciated.

[Rawb]

Well, it sounds like you already know what to do. Just use the .SetFocus Property of whatever Form field you want to jump to:

  If Me!Response = 7 Then
    Me!FieldD.SetFocus
  Else
    Me!FieldA.SetFocus
  End If

You'll need to change the items in bold to the actual Form fields.

[kkhubb]

Yes, thank you! I was getting tangled up in the dang syntax, (think I looked at it for too long!) It really was that simple, again, THANK YOU!