I have a query already set up in the background that appends data from table_1 to table_2…. Using the month and year criteria….
How do I create a form that allows the user to select the appropriate month and click on the execute button – which alters the query in the background and runs it?
What I have already created is a table called “Date_Selection” Which holds a list months in a year. How do I link that to the query? For example, the user will select “February” and execute…. Hopefully the month selected will populate the criteria in the query and run it….