I have a text box "Label Printed" on a form for whether or not a label has been printed (yes/no, default is no). I also have a print button "Print Box Label" on that same form. I would like the text box to be updated to "Yes" when I use the print button. Is there some simple code for this action?
Print Button Question
- Thread starter Hydra427
- Start date
Do I add that to the print button code or the test box code?
- Local time
- Yesterday, 23:55
- Joined
- Oct 29, 2018
- Messages
- 22,767
If you want the Textbox to change then you click on the button, you would add the code to your button.
OK, I can get the text box to change but am having trouble figuring out how to print my report based on the current record in the form. I thought about using
DoCmd.RunCommand acCmdSelectRecord
DoCmd.printout acselection
But that does not pull in the report that I want to run which is "Box Label Report"
I also thought about using a macro to print the report but how would I add the Me.[Text Label]="Yes" to the Macro?
Thanks, John
DoCmd.RunCommand acCmdSelectRecord
DoCmd.printout acselection
But that does not pull in the report that I want to run which is "Box Label Report"
I also thought about using a macro to print the report but how would I add the Me.[Text Label]="Yes" to the Macro?
Thanks, John
