Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenReport problem

Status
Not open for further replies.

DavidDF

MIS
Jan 19, 2003
8
US
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top