Text box population with string

  • Thread starter Thread starter Brandon Schultz
  • Start date Start date
B

Brandon Schultz

I have a text box I have populated with a string. The string calls out to
some sub reports. It looks good but when a particular record has multiple
values linked in the sub reports it only displays the first record from
them. Here is an example of my code:

Me.txtConcerning = "This concerns Complaint # " & Me![intComplaintNumber] &
_
", " & "Product # " & Me![chrProductID] & " " & _
", " & "Invoice # " &
Me![subInvoicesComplaintResponseReturnMat].Report![intInvoiceNumber] & _
", " & "Run # " &
Me![subLotsComplaintResponseReturnMat].Report![lngLotNumber] & _
", " & "PO # " &
Me![subCustomerPOComplaintResponseReturnMat].Report![chrCustomerPO]

Any suggestions would be appreciated.

Thanks,

Brandon Schultz
 
All of the pertinent records from the subreports. It only shows the first
record in the report.
Thanks,

Duane Hookom said:
What would you like to display?

--
Duane Hookom
MS Access MVP


Brandon Schultz said:
I have a text box I have populated with a string. The string calls out to
some sub reports. It looks good but when a particular record has multiple
values linked in the sub reports it only displays the first record from
them. Here is an example of my code:

Me.txtConcerning = "This concerns Complaint # " & Me![intComplaintNumber] &
_
", " & "Product # " & Me![chrProductID] & " " & _
", " & "Invoice # " &
Me![subInvoicesComplaintResponseReturnMat].Report![intInvoiceNumber] & _
", " & "Run # " &
Me![subLotsComplaintResponseReturnMat].Report![lngLotNumber] & _
", " & "PO # " &
Me![subCustomerPOComplaintResponseReturnMat].Report![chrCustomerPO]

Any suggestions would be appreciated.

Thanks,

Brandon Schultz
Click to expand...
Click to expand...
 
There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
function can combine several child records into a single expression.

--
Duane Hookom
MS Access MVP


Brandon Schultz said:
All of the pertinent records from the subreports. It only shows the first
record in the report.
Thanks,

Duane Hookom said:
What would you like to display?

--
Duane Hookom
MS Access MVP


Brandon Schultz said:
I have a text box I have populated with a string. The string calls out to
some sub reports. It looks good but when a particular record has multiple
values linked in the sub reports it only displays the first record from
them. Here is an example of my code:

Me.txtConcerning = "This concerns Complaint # " &
Click to expand...
Me![intComplaintNumber]
&
_
", " & "Product # " & Me![chrProductID] & " " & _
", " & "Invoice # " &
Me![subInvoicesComplaintResponseReturnMat].Report![intInvoiceNumber] & _
", " & "Run # " &
Me![subLotsComplaintResponseReturnMat].Report![lngLotNumber] & _
", " & "PO # " &
Me![subCustomerPOComplaintResponseReturnMat].Report![chrCustomerPO]

Any suggestions would be appreciated.

Thanks,

Brandon Schultz
Click to expand...
Click to expand...
Click to expand...
 
Back
Top