crosstab parameter

[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,

 

[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.

 

[Souris]

Thanks millions,

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.

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,