Change form layout from table to query?

[Trey Ormsbee]

I have small access database... It is nothing special and
is not big. This post may have to much info or two less
but here goes.

I have 5 tables, (one table is a backup and is not used)
I have 4 forms, one for each table.

One of the forms is a start form, you have to start with
that form to use the others, (it opens up and queries for
whatever it need)

I have come across the need to chagne my main "start" form
from pulling information from its corresponding table. To
pull it from a query instead. I have records in the table
that I no longer need access to in the form.

I would like to know if there is a(n) (easy) way to copy
the form and change each field to pull from the query
instead of the table?

I could just recreate the entire form.. but its a little
time consuming if there is an easier way I would like to
try it.

Thanks
Trey

 

[sanfu at techie dot com]

I have small access database... It is nothing special and
is not big. This post may have to much info or two less
but here goes.

I have 5 tables, (one table is a backup and is not used)
I have 4 forms, one for each table.

One of the forms is a start form, you have to start with
that form to use the others, (it opens up and queries for
whatever it need)

I have come across the need to chagne my main "start" form
from pulling information from its corresponding table. To
pull it from a query instead. I have records in the table
that I no longer need access to in the form.

I would like to know if there is a(n) (easy) way to copy
the form and change each field to pull from the query
instead of the table?

I could just recreate the entire form.. but its a little
time consuming if there is an easier way I would like to
try it.

Thanks
Trey

Just create a new query with all of the fields from the main form's
table (add the table and drag down each field to the grid). Set the
criteria to eliminate the records you don't want. You can also set the
Sort order. Then set the main form's record source to the name of the
new query. That's it...