I have a report using a crosstab query in a graph. The query is asking for
parameters. When I try to pass the parameters to a text box on the graph
they will not pass through. I am building it in text box in an expression.
Any suggestions?

I would expec the parameters to come from controls on a form. You should be
able to add text boxes to the report near the graph with control sources like:
=Forms!frmParameters!txtStartDate
--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/...ddbuz/threads?


"Alaska1" wrote:

> I have a report using a crosstab query in a graph. The query is asking for
> parameters. When I try to pass the parameters to a text box on the graph
> they will not pass through. I am building it in text box in an expression.
> Any suggestions?

The data is actually in table and in the query. I do not have that data
displaying on the form. Only in the table and the query.

"Duane Hookom" wrote:

> I would expec the parameters to come from controls on a form. You should be
> able to add text boxes to the report near the graph with control sources like:
> =Forms!frmParameters!txtStartDate
> --
> Duane Hookom
> Microsoft Access MVP
>
> NOTE: These public News Groups are ending June 1st. Consider asking
> questions at http://social.answers.microsoft.com/...ddbuz/threads?
>
>
> "Alaska1" wrote:
>
> > I have a report using a crosstab query in a graph. The query is asking for
> > parameters. When I try to pass the parameters to a text box on the graph
> > they will not pass through. I am building it in text box in an expression.
> > Any suggestions?

If your criteria values are stored in a table, you can either use the table
in the record source of a report/subreport or use DLookup() or use code.

--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/...ddbuz/threads?


"Alaska1" wrote:

> The data is actually in table and in the query. I do not have that data
> displaying on the form. Only in the table and the query.
>
> "Duane Hookom" wrote:
>
> > I would expec the parameters to come from controls on a form. You should be
> > able to add text boxes to the report near the graph with control sources like:
> > =Forms!frmParameters!txtStartDate
> > --
> > Duane Hookom
> > Microsoft Access MVP
> >
> > NOTE: These public News Groups are ending June 1st. Consider asking
> > questions at http://social.answers.microsoft.com/...ddbuz/threads?
> >
> >
> > "Alaska1" wrote:
> >
> > > I have a report using a crosstab query in a graph. The query is asking for
> > > parameters. When I try to pass the parameters to a text box on the graph
> > > they will not pass through. I am building it in text box in an expression.
> > > Any suggestions?