Connecting Tech Pros Worldwide Forums | Help | Site Map

Print the Report from the Form in MS Access 2003

Newbie
 
Join Date: Jun 2006
Location: Dammam-Saudi Arabia
Posts: 2
#1: Nov 14 '07
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

nico5038's Avatar
Moderator
 
Join Date: Nov 2006
Location: The Netherlands
Posts: 2,232
#2: Nov 16 '07

re: Print the Report from the Form in MS Access 2003


You'll need to check your form for the field TxtCOPY to be present.
Open the Other tab to check the controlnames!

Nic;o)
Reply