I have a query that creates a list of e-mails on the fly from current data. The user uses a form with a drop down selector to run the make table query, and the query uses the critera from the drop down list as type of customer to generate the lists. The problem is...since it is a make table query...it saves the data to the same table no matter what customer type is selected.
Is it possible to have the table name mimic the customer type from the drop down list?
My customer type criterea in the query is
[Forms]![E-Mail criteria]![Combo2]
I tried plugging that in to the make table name field but it didnt work. How would I go about this? HELP?
Is it possible to have the table name mimic the customer type from the drop down list?
My customer type criterea in the query is
[Forms]![E-Mail criteria]![Combo2]
I tried plugging that in to the make table name field but it didnt work. How would I go about this? HELP?