Subreport RecordSource Property 2

K

Ken Snell

Your expression will return either a True or False result, not a
RecordSource string.

To set the RecordSource of a subreport:

Me.rpt_Employee_Info_Sub.Report.RecordSource = "q_rptEmployeeInfoSub"
 
S

Scott

from my report's open event, i'm using the below code to change the
recordsource of my subreport. it gives me an error saying "expression has an
invalid reference to the property form/report"

can someone check my syntax?


Me.rpt_Employee_Info_Sub.Report.RecordSource = Me.RecordSource =
"q_rptEmployeeInfoSub"
 

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

SubReport RecordSource 3
Word macro that can call cells out of Excel for a find and replace 0
subreport recordsource 1
DLookup Missing RecordSource Question 2
Change RecordSource for Report; Subreports 2
Filter & Requery Subform 5
Changing Recordsource Property in subreport 3
Set Recordsource for a subreport 4

Top