I would like to take several different queries and combine the information 

into a single recordset.  I have managed to "create" this mixed recordset 

fine, however I can not figure out how to get the recordset to display in 

a subform.  I attempted to assign the recordset to the recordset property, 

but I get an error:  



Runtime error '7965'

The object you entered is not a valid recodset property



The record set is an ADO recordset.  Does anyone know how to make this 

work?  Or even if there is a better way to piece together information from 

multiple select statements (which are from different tables).



Miriam

One way would be to make multiple "append" queries so combining all your 

queries into 1 table.

Then base your subform on this table

No VB needed

If this needs to be automated - just make a makro to call all these append 

queries before a form opens (if that is still necessary)



I hope that helps

Deon