Macro and Conditional Expression

  • Thread starter Thread starter B Bach via AccessMonster.com
  • Start date Start date
B

B Bach via AccessMonster.com

Hello,

I have a subform with a 1/0 response. I would like to send the User to the
next subform based on the response in this field. For example, If the User
types 1 then Open Next Subform, If the User types 0 then "don't do anything
and just continue on to the next variable.

I started a Macro with

condition column [FieldName]=1
action column OpenForm
Go to Record
I know I am missing something in this ... anyone have any suggestions ?

Thanks
 
You left out part of the identification --
condition column [Forms]![YourForm]![FieldName]=1
 
B Bach,

What you have done is fine. Although there should be an entry in the
Condition column for the GoToRecord action like this:
...

So is there some problem? What's happening? If it's not working as
expected, it is more likely to be caused by what you *haven't* told us,
i.e. what event are you running the macro on, and what have you entered
for the macro arguments, e.g. Form Name argument of the OpenForm action.
 
Back
Top