crosstab parameter

S

Souris

I need pass parameters to my crosstab query from different forms.

May I use me![txtParam] as parameter to suppert every forms using same
crosstab queries?

Your information is great appreciated,
 
J

Jerry Whittle

You need to use the [Forms]![TheFormName]![txtParam] syntax.

Further I suggest putting the parameter in a regular query, then basing the
crosstab on this initial query.

You might also need a different set of queries for each form.
 
S

Souris

Thanks millions,


Jerry Whittle said:
You need to use the [Forms]![TheFormName]![txtParam] syntax.

Further I suggest putting the parameter in a regular query, then basing the
crosstab on this initial query.

You might also need a different set of queries for each form.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Souris said:
I need pass parameters to my crosstab query from different forms.

May I use me![txtParam] as parameter to suppert every forms using same
crosstab queries?

Your information is great appreciated,
Click to expand...
Click to expand...
 
Top