I am using OpenReport to pass values from a form. The primary AutoNumber field (CustomerNum) indicates that only the current record should be printed. Does CustomerNum have to be converted to a string value first? Example with no conversion:
Dim strName as String
Dim strWhere as String
strName = "CurrentRcdReport"
strWhere = "[CustomerNum] = " & Me![CustomerNum]
DoCmd OpenReport strName,,,strWhere
At first this worked but now I get a box requesting a parameter then a number of #Error 's that seem to match the number of lines in the single rcd report.
Any help will be appreciated.
David
Dim strName as String
Dim strWhere as String
strName = "CurrentRcdReport"
strWhere = "[CustomerNum] = " & Me![CustomerNum]
DoCmd OpenReport strName,,,strWhere
At first this worked but now I get a box requesting a parameter then a number of #Error 's that seem to match the number of lines in the single rcd report.
Any help will be appreciated.
David