If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record Displayed In Form Is The Record Printed In Report
The subform is contained by the mainform, therefore I think you need to give the full path for reaching the ServiceDate field. Try:
[Forms]![FrmMainDataEntryForm]![FrmServicesSubForm]![ServiceDate]. I'm not positive if this will work, but it's simple to try! ----- Kathy R. wrote: ----- 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. |
Thread Tools | |
Display Modes | |
|
|