|
Hi readers
I have an application in MS Access 2003 and having 2 forms i.e. Quotation & Invoice and I created their reports in crystal report and convert these reports in EXE files now i wanted to run these reports through form Print button.
i mean to say if user enter any quotation or invoice then he will press print button and specific quotation or invoice will come out and also needs to know if i need 3 copies so in first print it will show "ORIGINAL" then rest of 2 copies will mentioned as "COPIES"
Following is the code i am trying to execute
Dim strCriteria As String
For intI = 1 To Me!TxtCOPY
strCriteria = "[qno]= " & Me.[qno]
DoCmd.OpenReport "rpt_qhead", asPreview, , strCriteria
Next
But at the time of execution the following error is generating
Run-time error '2465'
Microsoft Windows Access can't find the field "TxtCOPY" reffered to in your expression
Kindly assist in this regards
|