How to change recordsource of report with code

  • Thread starter Thread starter Martin
  • Start date Start date
How can I change the record source of a report with code?

Martin.
Click to expand...

You haven't given a heck of a lot to go on :-(

One way is to code the Open Event of the report:
If forms!FormName!SomeControl = SomeCriteria Then
Me.RecordSource = "Query1"
Else
Me.RecordSource = "Query2"
End If

If you need more, you'll have to give more.
 
Thank you, this was enough.

Martin.


fredg said:
You haven't given a heck of a lot to go on :-(

One way is to code the Open Event of the report:
If forms!FormName!SomeControl = SomeCriteria Then
Me.RecordSource = "Query1"
Else
Me.RecordSource = "Query2"
End If

If you need more, you'll have to give more.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

change report recordsource 1
Setting Report's RecordSource 8
Text of a RecordSource 2
change recordsource of subreport? 4
Change RecordSource for Report; Subreports 2
Change Report RecordSource Property with VBA. 5
subreport recordsource 1
Subreport with different recordsource 1

Back
Top