Referencing subforms on reports!

[paulmcdonnell]

Hi Guys!!!

I'm using a form (A) which checks information from a settings page (B) which is a subform on A. This all works fine.

I then created a report (C) and want conditional formating to use the same subFORM (B) as the report (A). I have the subform (B) inserted into the report (C) but I'm having trouble referencing controls on this form.

For Forms and Subform Controls I'm using -

[TotalOutlay]<=[Forms]![Form_ANALYSIS_Properties]![Sunform_Margin_Settings].[Form]![Margins_low_Total_Outlay]
(Works fine ACCESS XP)

For the Report and Subform controls I'm using -

[Reports]![Report_Analaysis_Individual_Property]![Sunform_Margin_Settings].Form![Margins_low_Total_Outlay]

Access doesn't like this...I'm assuming its possible to mix forms and reports like this ...

Can anyone point to the right referencing method.

Cheers
PAUL

 

[Rich]

You mean Report and subReport?

 

[paulmcdonnell]

No, I mean report and subFORM.

I can insert a subform into a report but to save creating a subreport which is the same as the subform i already have can't I reference controls on the inserted form on the report?

Cheers
Paul

 

[Rich]

I think the form still becomes a subReport and is therefore referenced by Report. and not Form