if this...then go to this field

  • Thread starter Thread starter Cal Miyatake
  • Start date Start date
C

Cal Miyatake

I am new to access xp. I am not very adept at creating
macros and need to create one that will do the following:

If the value in the current field is "x" then go to
another field so that I can select an entry from the drop
down list . How do I do that?
 
MacroName
Condition: Forms!FormName!ControlName.Value = "x"
Action: GoToControl
Control Name: Forms!FormName!SecondControlName
 
My apologies. I was not clear. My intent is to state:

If the value in the current field is "x" then go to
another field so that I can select an appropriate entry
from the drop down list; if not, then go to another
specified field so that I can select from that drop down
list. It's really an IF-Then statement. Also, I am
trying to use the Macro Builder from within Access XP vs
writing the script. Thanks.
 
What I posted is what you asked for. Simply put the macro as the macro on
the AfterUpdate event of the control that has value "x".
 
Back
Top