I created a new query and saved it using the make-table procedure, but I
cannot figure out how to view the results using my existing forms. I
recently upgraded from Access 2000, so everything is taking on a new look for
me.
A MakeTable query does just that - makes a new table. It's no longer a query;
you have a separate, redundant copy of the data. It's *occasionally* useful to
do this but I find that situation to be rare.
You can set a Form's Recordsource property to the name of a table (your newly
made table, say), or to the name of a SELECT query (as distinct from a
make-table query); or even to a SQL string returning records.
Of course, the fieldnames and datatypes in the query must match with the
Control Source properties of controls on the form for the form to usefully
display data. It would be quite unusual to have *several different forms* all
viewing one table - what are the recordsources of these forms, and what was
your original query?
John W. Vinson [MVP]
