Dynamic report, populated by combobox

[gmaster]

Hi guys, i'm kinda noob in the report field and i wanted to ask if it's possible to make a report that populates its fields with tables chosen by a combobox.


Example: i have a form with a combobox where i can chose from a dozen table names, then a button opens the report. Now, all those tables have, among others, 3 identical fields (same name, same property. Yes, it's not normalized. No, i can't change it ), so it would be perfect if there was a way (VBA i guess) to make it populate these 3 fields in the report (that only has those 3 columns) with data coming from the table selected in the combobox, so i don't have to make dozens of reports almost identical, but only one....
Thanks, hoping i have explained myself

[June7]

It is possible. One way is to set the report RecordSource property. I do this for one report.

Code behind the report:

Private Sub Report_Open(Cancel As Integer)
'report is called by SampleManagement and zPre2009SamplesView forms to print list of samples
'set RecordSource to pull data from appropriate tables
Me.RecordSource = Nz(Me.OpenArgs, Me.RecordSource)
End Sub

Code that opens the report from two locations - it passes the SQL string for the report RecordSource in the OpenArgs argument:

DoCmd.OpenReport "SampleList", IIf(booView = True, acViewPreview, acViewNormal), , Replace(Me.Filter, "zPre2009SamplesView", "SampleList"), , Me.RecordSource

DoCmd.OpenReport "SampleList", acViewPreview, , Me.ctrSampleList.Form.Filter, , Me.ctrSampleList.Form.RecordSource


Another approach might be a UNION query of the dozen tables and use the UNION as report RecordSource and apply filter to report.

SELECT 1 As Source, field1, field2, field3 FROM Table1
UN ION SELECT 2, field1, field2, field3 FROM Table2
...;

[gmaster]

Thanks, made it work!