report forms-using same form for different queries

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

I'm printing a report from a query, and need a report
with the same format and appearance from a different
query. How do I do this without having to make the
report from scratch twice?
thank you
 
I got this from Fred

You can also use just one report for both queries, by
simply deleting the recordsource and leaving it blank.
Then code the Report Open event to set it's recordsource
there, according to a user selected value on a form:
If forms!FormName!OptionGroupName = 1 Then
Me.RecordSource = "Table1"
Else
Me.RecordSource = "Table2"
End If
The form would have to be open when the report is run.

Jim
 
Back
Top