Record Displayed In Form Is The Record Printed In Report

K

Kathy R.

Form - company name and other info - one record per
company.
Subform - has multiple service records for the company,
service records have a date, can have more than one per
date for a company.
The two tables are linked by Company Name field.
Question: I wish to ship the displayed company record and
the single service record that is displayed to a report.
In the report query it understands [Forms]!
[FrmMainDataEntryForm]![Company]and selects the right
company record. But it doesn't understand [Forms]!
[FrmServicesSubForm]![ServiceDate]. ServiceDate is not
unique. Thanks.
 
Top