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

 

[seaport]

My suggestion is to use "Make Table" query to create a tempoarary table "_temp", on which you build the crosstab query.
Assuming that your standard query is Query1 and the crosstable query is Query2.
Before open Query2, run the following code first in VB:
Docmd.runsql "select * into _temp from query1 where " & strDateCriteria
Then you will get the correct result when you open Query2.


Seaport