union query problems

[dubmunkey]

Hi all,

i have this query which utlises a vb function allowing you to filter a table or query by the value of a form drop down- works great!

what i now need to do is do the same on a query which combines the same data with some user added data (all fields are the same) from another table- so two tables with identicle fields being combined by a union query- then query that using the criteria from my vb function

well in theory that should work but it doesn't- doesn't matter what i try i always get no results-

any ideas why this fails? what is it about union queries that stops you from doing simple things like this even though the fields are the same?

dubs

 

[KeithG]

Sorry I don't really understand what you are saying. Are you create a join from the union qry to another query? Can you post an example db?