There is no easy way to address your question because that is NOT the way
things work. To understand how things DO work, you need to understand a
little bit more about the objects in Access.
First, Access contains several different kinds of objects (tables, forms,
queries, reports, etc.) Each of these classes, or kinds of objects, performs
a different task. And understanding that is crucial to figuring out what you
need (want) to do here.
First, tables are the storage containers of the database. You might think of
them somewhat like a set of cannisters in your pantry. Tables are there only
to hold data. You can re-fill and empty the flour container many, many times
as you buy new bags of flour to pour into the container. Each time you want
to bake bread, you go to the flour container to get the flour you need.
In a database, of course, data is always going into the tables as new
information is gathere, but it is generally not the case that people delete
the data once it's there.
The important thing to keep in mind is that the data is stored in tables and
available to other objects in the database as it is needed for tasks like
generating a report.
Reports are the delivery vehicles of the datbase. You might think of them as
the cake pan in which you pour batter for baking. They are templates which
allow you to structure and present data pulled from the tables at various
times and in various combinations.
Now, for forms, which is the subject of your question.
Forms are, essentially, the object, or tool, in which you TEMPORARILY hold
data while you are preparing it for storage in a table, or for presentation
in a report.
You might think of forms as the measuring cups, mixing bowls and spoons you
use to prepare ingredients (i.e. data) for a new cake, or you might think of
them as the paper bags and boxes in which you bring home raw ingredients
which you will transfer to your own containers (i.e. tables) in your pantry
(i.e. database).
So, it makes no sense to talk about creating a table from a form. That would
be the equivalent of saying that you want to convert a glass mixing bowl
into a bag of sugar.
So, perhaps you can explain, in more detail, what you are trying to
accomplish and why you need to do it.
George
