I want to create a make table Query which I need to use later with a series of queries and reports but want to create from an open form. I will place a command button to run the query on form.
SELECT * INTO temptable name
FROM "The tablename I want to copy is the value in a field "DE" on my open form "View";
SELECT * INTO temptable name
FROM "The tablename I want to copy is the value in a field "DE" on my open form "View";