Pass standard query Criteria to Crosstab...

[dodgyone]

I have a standard query and a crosstab query is based on the result of the standard query. The crosstab is displayed as a subform on a form for viewing purposes etc.

In the standard query is a date column and this is always changing so the user is asked to enter the date before the query gives the results (i.e. the appropraite colums have been edited so that it asks for the date as it opens).

The problem is that the crosstab query is obviously not being updated as the dates in the standard query are not fixed. So, the form which displays the crosstab query does not give any results.

I have tried using a text box in a form, passing the date from there to the query and then opening the form with the crosstab result but no joy.

Has anybody got any suggestions?

Thanks,

Marcus

 

[RMasters]

Have you tried refreshing the form/sub-form after you run the query? I'm not sure if this will work but if you are out of ideas then try it.