Macro and Conditional Expression

[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

 

[Guest]

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

 

[B Bach via AccessMonster.com]

It's a subforms so I proably have to reference the main forms and then the
subform ..?

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

Hello,

[quoted text clipped - 11 lines]

Thanks

 

[Steve Schapel]

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.

 

[Guest]

Right.

It's a subforms so I proably have to reference the main forms and then the
subform ..?

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

Hello,

[quoted text clipped - 11 lines]

Thanks