Hi,
I am using a text box as the subject for an invoice email.
The textbox works fine for listing individual fields from the
tblOrders table as shown below:
="Hi, " & [First] & "
" & "Your order is as follows:" & "
" & "
" & "Order ID: " & [OrderID] & " " & " Order Date: " &
Format([OrderDate],"Short Date") & " " & " Ship Via: " & [ShipMethod]
& "
" & "
" & " Subtotal: " & Format([ItemsTotal],"Currency") & "
" & " Tax: " & Format([OrderTax],"Currency") & "
" & " Insurance: " & Format([OrderInsurance],"Currency") & "
" & " Shipping: " & Format([ShipPrice],"Currency") & "
" & " Total: " & Format([OrderTotal],"Currency") & "
Yields:
Hi, Shaleana
Your order is as follows:
Order ID: 472 Order Date: 12/25/2003 Ship Via: USPS Priority
Subtotal: $15.00
Tax: $0.00
Insurance: $0.00
Shipping: $3.85
Total: $18.85
This works great, but I'd like to add the Item details that come from
a separate table tblOrderDetails and are linked by the OrderID field.
It seems I need to loop through a recordset for the details but I am
not sure how to get the details onto the text box if it is linked to
the Orders table.
Can anyone help??