I need help creating a query that will set the criteria to a chosen value from a combo box.
Basically, the combo box has a drop down list of date/location for the user to choose from. Once they choose the date/location (they are linked in the same combo box already) they want, I want to have a command button that will run a query and paste append.
I would like the query to not only paste append the date/location the user chooses, but also all records matching that date/location with additional fields (name, #, user name).
The combo box drop list values comes from a different query.
Here is what I put in the criteria boxes for date & location based on a website I found:
[Forms]![Create A Profile]![Combo4]
The form is titled "Create A Profile" and the combo box is titled "Combo4"
I can select the date/location, but when I hit the run command button, nothing happens, not even a pasting of the date/location.
Basically, the combo box has a drop down list of date/location for the user to choose from. Once they choose the date/location (they are linked in the same combo box already) they want, I want to have a command button that will run a query and paste append.
I would like the query to not only paste append the date/location the user chooses, but also all records matching that date/location with additional fields (name, #, user name).
The combo box drop list values comes from a different query.
Here is what I put in the criteria boxes for date & location based on a website I found:
[Forms]![Create A Profile]![Combo4]
The form is titled "Create A Profile" and the combo box is titled "Combo4"
I can select the date/location, but when I hit the run command button, nothing happens, not even a pasting of the date/location.
