Hiya, I have a report which holds all information regarding Advertising Campaigns, and comprises a subreport which displays all the suppliers which belong to the advertsing campaigns (One to many relationship, linked on an ID field). I have the Subreport in the details section of my report. The way I want the information diplaying is all on one line for example.
Date Publication Suppliers
12/07/2002 The Times Cobblers Cove, Treasure beach, The Hilton
To get the suppliers on the same line as the others (suppliers come from the sub report), I figured if I put a text box (call it Allsuppliers) along side the other fields in the ID footer, and then in the Detail Format section include code such as
If Not Firstpass Then
Me!AllSuppliers = Report.RptSubSuppliers![SuppName]
Firstpass = True
Else
Me!AllSuppliers = Me!AllSuppliers & ", " & Report.RptSubSuppliers![SuppName]
End If
Remembering to reinialise firstpass and allsuppliers when required.
This code seems to work but my problem , when running the report, if there is no matching ID in the subreport it displays a msg “The Value you entered isn’t valid for the field.”
Can anyone please help. I’ve tried ignoring the code if isnull, but that doesn’t seem to work.
Thanks
Date Publication Suppliers
12/07/2002 The Times Cobblers Cove, Treasure beach, The Hilton
To get the suppliers on the same line as the others (suppliers come from the sub report), I figured if I put a text box (call it Allsuppliers) along side the other fields in the ID footer, and then in the Detail Format section include code such as
If Not Firstpass Then
Me!AllSuppliers = Report.RptSubSuppliers![SuppName]
Firstpass = True
Else
Me!AllSuppliers = Me!AllSuppliers & ", " & Report.RptSubSuppliers![SuppName]
End If
Remembering to reinialise firstpass and allsuppliers when required.
This code seems to work but my problem , when running the report, if there is no matching ID in the subreport it displays a msg “The Value you entered isn’t valid for the field.”
Can anyone please help. I’ve tried ignoring the code if isnull, but that doesn’t seem to work.
Thanks