Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reach a subForm on a report

Status
Not open for further replies.

lonchi

Programmer
Jan 30, 2002
12
MX
Hy every one,
I am tryng to update a row source of a control that is on a Report.
I tried several methods, but I don't seem to get it working.

I figured that I can place a subForm on a Report and than get to its's control RowSource.

My code is like this :
[Report]![ReportName].[Form]![sfrmOnReport]![ControlNameOnsfrmOnReport].RowSource = strSQL

This does not work.
I get " Microsoft Access can't find field '|' referd to your expression.

The whole idea is to make a report depending on wat is selected on the form.

If anyone has another mathod for achierf this, pleas let me know.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top