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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with current record printing

Status
Not open for further replies.

Mackooo

MIS
Nov 17, 2005
18
US
I have problem printing with current record, here is the code that I been using

Private Sub CmdPrintECN_Click()
Dim strReportName As String
Dim strCriteria As String
strReportName = "rptItem"
strCriteria = "[Item_number]='" & Forms!items_log.[Txtitem_number] & "'"
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

End Sub
 
What happens when you try that?
Any errors, or just not showing the correct data?
Is your report linked to a query if so, why not add that to the query?
Or do you have a control on the report that has no value that you are entering this value for?

I want to help, I just don't understant what youre trying to accomplish here.



-Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top