I feel like this is pretty simple, but in searching I cannot seem to find the precise answer I'm looking for.
What I have is an Access form with a textbox that the user will enter a date into, formatted "3/30/2017".
I have VBA that exports a table using DoCmd.TransferSpreadsheet, and on the Name parameter I'm setting it to tack the date onto the end of the exported file name, such as:
Environ("USERPROFILE") & "\Desktop\filename" & Format(Date, "mmddyy") & ".xlsb"
This works, but ideally I'd like the date that was entered onto my Form to take the place of & Format(Date, "mmddyy") &
What's the proper syntax to use to call that form field and format it on the end of my file name in the same format of "mmddyy"?
Thanks!