I have a form where the user selects a date range for which to run some reports. Currently there is a separate menu option to process the monthly imports to prep the data for reporting. The excel files that are imported into Access are manually named each month with the month and year as part of the file path and name (the rest of the file path and name are consistent.) Can I take inputs from the form where the user defines the date range to run the reports for to feed the import statements the proper path and file names, rather than having to manually change those each month prior to running the import process ? Thanks !