crosstab parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Souris - 16 Apr 2008 13:34 GMT

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,

Reply to this Message

Jerry Whittle - 16 Apr 2008 15:34 GMT

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.

Signature

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,

Reply to this Message

Souris - 16 Apr 2008 16:04 GMT

Thanks millions,

> You need to use the [Forms]![TheFormName]![txtParam] syntax.
>
[quoted text clipped - 9 lines]
> >
> > Your information is great appreciated,

Reply to this Message