Private Sub Command69_Click()
Dim idVar
idVar = Forms![D-E-1-LineHaul]![D-E-2-LineHaul-Shipment_Detail]!ID
DoCmd.OpenReport "TX-TrailerUnloadReport", acViewPreview, , "ShipmentID = " & idVar
End Sub
Hi,
I am getting a run time error of 3464 data type mismatch in criteria expression. I run the debugger and it highlights the line docmd.OpenReport. I have compared a previous copy of the code in working form and it appears to be the same code. Is this just human error?