GoTo Field based on input

  • Thread starter Thread starter Marianne
  • Start date Start date
M

Marianne

Does anyone know how to skip to another field based on the
value of another field? For example, in this survey I'm
doing, if someone answers yes, then I have to skip 4
fields to input the next answer. I'm not sure if this
would be an expression, macro or code. I've tried playing
around in each one. There's a macro action that will go
to an assigned field, but I don't know how to set up the
If part, i.e. If the answer is yes, then. . ..

Any help would be appreciated. TIA
 
In the AfterUpdate event of the first textbox:

If Me!FirstTextBox="Yes" then
Me!NextTextBox.setfocus
End if
 
Back
Top