Passing data from a form to report field

[Guest]

I made a form that passes data from a popup to the report so I don't have to
make duplicate pages.

The form name is "Chooser"
The variable name is "Type"

If I hard code the value from the form like this it works fine:

=Sum(IIf([Product Type]="Soccer",[Volume],Null))

But when I pass the variable it doesn't. (I'm sure I'm just missing a
bracket or something)

=Sum(IIf([Product Type]="[Forms![Chooser]!Type]",[Volume],Null))

Any ideas?

-Adam

 

[Guest]

Hi Adam;

try: =Sum(IIf([Product Type]=Forms![Chooser]!Type,[Volume],Null))

I think you just over cooked it a little.

Best;

Rob.

 

[Guest]

=Sum(IIf([Product Type]="[Forms]![Chooser]![Type]",[Volume],Null))
You were just missina couple of brackets.

 

[Guest]

I'll try both of the suggestions when I get home tonight.

I appreciate the help.

-Adam

=Sum(IIf([Product Type]="[Forms]![Chooser]![Type]",[Volume],Null))
You were just missina couple of brackets.

I made a form that passes data from a popup to the report so I don't have to
make duplicate pages.

The form name is "Chooser"
The variable name is "Type"

If I hard code the value from the form like this it works fine:

=Sum(IIf([Product Type]="Soccer",[Volume],Null))

But when I pass the variable it doesn't. (I'm sure I'm just missing a
bracket or something)

=Sum(IIf([Product Type]="[Forms![Chooser]!Type]",[Volume],Null))

Any ideas?

-Adam

 

[Guest]

Here's the code that works: =Sum(IIf([Product
Type]=Forms![Chooser]!Type,[Allocated Case Volume],Null))

I'll try both of the suggestions when I get home tonight.

I appreciate the help.

-Adam

=Sum(IIf([Product Type]="[Forms]![Chooser]![Type]",[Volume],Null))
You were just missina couple of brackets.

I made a form that passes data from a popup to the report so I don't have to
make duplicate pages.

The form name is "Chooser"
The variable name is "Type"

If I hard code the value from the form like this it works fine:

=Sum(IIf([Product Type]="Soccer",[Volume],Null))

But when I pass the variable it doesn't. (I'm sure I'm just missing a
bracket or something)

=Sum(IIf([Product Type]="[Forms![Chooser]!Type]",[Volume],Null))

Any ideas?

-Adam