crosstab parameter

  • Thread starter Thread starter Souris
  • Start date Start date
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,
 
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.
 
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,
 
Back
Top