More than 1 source on Form/Report

M

Machado

Can a Form or a Report has more than ONE source?? (ie. two or three queries)..
Thanks
 
O

Ofer

At the same time?
If you can join them, then yes.
Seperatly, No

To change the source depending on a condition, then yes, using code that
change on the load event of the form, that will change the recordsouce of the
form

If condition then
me.RecordSource = "QueryName"
Else
me.RecordSource = "Query2Name"
End IF

We need to know more about what you need
 
K

Keith

Machado said:
Can a Form or a Report has more than ONE source?? (ie. two or three
queries)..
Thanks
Click to expand...

Obviously not simultaneously, but you can set the RecordSource property of
the form or report in the On Open event using code.

Regards,
Keith.
www.keithwilby.com
 
K

Klatuu

Yes and No
If you are asking about chaning sources then that can be done programmatically
application.Reports("ReportName").RecordSource = "MyReportName"
If you are asking if one report can have multiple sources at the same time,
the answer is no. You will have to have a way to combine them into one
recordset or you will have to use one query for the report and a sub report
for each additional query.
 
Top