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!

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

need to print report from form without closing it

Status
Not open for further replies.
millrat

millrat

Technical User
Dec 23, 2003
98
US
Hi
How can I print my report from my form without first closing it. Currently when I fill out my form then select print report the report is blank. If I close the form then open it again it works OK. How can I get around this problem?
Thanks
millrat
 
Sort by date Sort by votes
Presumably you are opening the report from a command button on the form. If so, add code to the button to Save the Record first, then open the report.

DoCmd.Save AcForm "YourFormName"
OR
DoCmd.RunCommand AcCmdSaveRecord
OR
Me.Dirty = False

will all save the record.

HTH
Lightning
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
494
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
515
dhookom
dhookom
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
199
dhookom
dhookom
EwaFAMA
  • Locked
  • Question
ACCESS - Adding image from URL to the report 1
Replies
11
Views
3K
EwaFAMA
EwaFAMA
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
763
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top