Filter by Form with Union Query (2000)

[LindaR]

I have a form that has a Union query behind it so I can get everything from one table and everything from the other table. When I Filter by Form, the dropdown lists have Is Null and Is Not Null for the dropdown options. When I was using a query (behind the form) that didn't have the union query, it worked but it wasn't giving me the records from the other table that didn't have an outer join. Is there a way to get what a want using a Union Query? Thanks for your help.

[HansV]

I don't think you can. It doesn't work for Totals queries either.

(You could create a temporary table and use that as record source of the form, but that's not very attractive)

[LindaR]

Can you use a totals query with a filter by form if you create another query using the totals query - then use that behind the form instead of the totals query.

[HansV]

No, that doesn't make any difference, sorry.