I am attempting to create a Macro or Event Procedure that will export a report to PDF, and I'm running into a few problems.
1. File Name - I want the file name to be equal to the value of the texbox on an open form. Is this possible?
2. Hidden objects - The report contains text boxes that are supposed to remain invisible unless they contain text (this is done by event procedure). However, whenever I export with VBA or macro, those boxes are visible regardless of whether they contain text.
Thanks