Nolan Adams
New member
- Local time
- Yesterday, 19:48
- Joined
- Oct 13, 2004
- Messages
- 7
my application starts with a FORM named Start. On that FORM the user clicks on the desired action. This in turn opens another FORM(CheckOut). On the CheckOut FORM the user selects one or more items from a LIST BOX that has multi set to Simple in the Properties section. I then want to Print those items in a REPORT named CheckOutReport. To do this the user Clicks on a Label Box that has this code in the 'on click' Procedure in the Properties Box:
DoCmd.Close acForm, "CheckedOut"
DoCmd.Close acFOrm, "Start"
DoCmd.OpenReport ("CheckOutReport")
DoCmd.PrintOut (acSelection = CheckOutReport)
DoCmd.OpenForm ("Start")
I get the report just fine, but I also get the Form Start printed as a second print file. I do not want this second print file. How do I stop it from printing?
I have gotten a lot of execellent information from this forum and hope you can help with this problem. I am obviously very new to MSAccess, so please be very specific with your answer. Do not assume I know much of anything.
Thanks in advance.
DoCmd.Close acForm, "CheckedOut"
DoCmd.Close acFOrm, "Start"
DoCmd.OpenReport ("CheckOutReport")
DoCmd.PrintOut (acSelection = CheckOutReport)
DoCmd.OpenForm ("Start")
I get the report just fine, but I also get the Form Start printed as a second print file. I do not want this second print file. How do I stop it from printing?
I have gotten a lot of execellent information from this forum and hope you can help with this problem. I am obviously very new to MSAccess, so please be very specific with your answer. Do not assume I know much of anything.
Thanks in advance.
