NeedHelpASAP
New member
- Local time
- Today, 08:06
- Joined
- Jul 25, 2019
- Messages
- 7
Im wondering if it is possible to use the ExportWithFormating macro with an Output File dependent on a combo box and date picker located on separate forms. the expression I have right now isnt working
=P:...\Merch Database" & [Forms]![frmReports]![Combo256] & "\Copy of EmpRouteMatrix" & [Forms]![frmReports]![Combo256] & ".pdf"
(didnt include the entire file name as its pretty long but the first combo is the variable folder name and the second is connected to a date picker)
Is this possible in a macro or am I in over my head?
=P:...\Merch Database" & [Forms]![frmReports]![Combo256] & "\Copy of EmpRouteMatrix" & [Forms]![frmReports]![Combo256] & ".pdf"
(didnt include the entire file name as its pretty long but the first combo is the variable folder name and the second is connected to a date picker)
Is this possible in a macro or am I in over my head?