Using Forms to input selection critera to a query

[BillyB]

Good morning to this very helpful forum. I have a form that contains a textbox that the user inputs selection criteria that I use in a query.

The query3 is built using an outerjoin from one query1 (contains base information) that matches on a primary key to query2 that is a crosstab query.

When I use the form criteria without the crosstab query2 it works great. As soon as I add the outerjoin on the crosstab query I get the following message: "Microsoft Jet Database Engine does not recognize [Forms]![Form name]![Text box] as a valid field name or expression"

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=40781

 

[BillyB]

Thanks Rich but my problem is a little different in that the criteria applies to the base query (query1) and not the crosstab query. The crosstab only adds addtional data to those rows selected from the base.

I also tried creating another query over the top of this one and still had the same problem.