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

Data from a Form to a Report

Status
Not open for further replies.

3063

Technical User
Jan 17, 2003
63
US
I have a form that I would like to print out in a report. I have a print command set up on the form and it works, once I close down the form and bring it back up, but will not print the fields unless I close the form first and go back into the form. Here's the code in my Print Command:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "RptRoutingSlp"
stLinkCriteria = "[ControlNumberID]= " & Me.ControlNumberId
DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria

Any help would greatly be appreciated.


 
Are you entering new records?
If so, when are you saving the new record? You cannot print it until you have saved it.
 
Yes. It is a new record. I have done this on anothe form with the same fields and got it to print, just can't figure out what would be the difference.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top