Oh, I probably am...
Report Name: rptNewTMC
Query Name: qryNewTMC
SQL Statement: SELECT qryInvoiceDetails.ID, qryInvoiceDetails.[SETR ID], qryInvoiceDetails.[Reference File], qryInvoiceDetails.[TMC Invoice], qryInvoiceDetails.[Date Paid], qryInvoiceDetails.[Invoice ID (File #)], qryInvoiceDetails.Vendor, qryInvoiceDetails.[Vendor Invoice #], qryInvoiceDetails.[Vendor Date Paid], qryInvoiceDetails.[Amount Paid], qryInvoiceDetails.[Taxes (GST)], qryInvoiceDetails.Parts, qryInvoiceDetails.Labour, qryInvoiceDetails.Sublet, qryInvoiceDetails.[Vendor Invoice Date], qryInvoiceDetails.VIN, qryInvoiceDetails.Mileage, qryInvoiceDetails.[Reg Date], qrySETRsub.[Sum Of Parts], qrySETRsub.[Sum Of Labour], qrySETRsub.[Sum Of Sublet], qrySETRsub.[Sum Of Recovered ($)]
FROM qryInvoiceDetails INNER JOIN qrySETRsub ON qryInvoiceDetails.[SETR ID] = qrySETRsub.[SETR ID]
WHERE (((qryInvoiceDetails.[SETR ID])=[SETR]) AND ((qryInvoiceDetails.[TMC Invoice]) Is Null))
ORDER BY qryInvoiceDetails.ID;
Field Name: TMC Invoice
Text Box Name: txtTMCinvoice
Here is the current code:
Private Sub cmdUpdateTMC_Click()
DoCmd.RunSQL "UPDATE qryNewTMC SET qryNewTMC.TMC Invoice = " & _
"Reports!rptNewTMC!txtTMCinvoice"
End Sub
All I can say is I'm sure glad it is Friday, and I don't have to worry about it all weekend. Thank you so much for your help!