How do I delete a subform and keep all the information?

I can't figure out quite what you need to do, but I wonder if there is some
confusion of terminology. An Access database is a file that contains what
are referred to as Objects (tables, queries, forms, reports, and a couple of
other things). Another database would be a separate file.
Looking at relationships is the way to see what table another table is
"looking at". It is not a big deal, and could provide information pertinent
to the question at hand.
It would help if you explain what your database does, how it is set up (in
general terms), and to what type of file you wish to export the data. If you
are exporting data from related tables into a flat file such as a spreadsheet
you may not be able to achieve satisfactory results.

"Carol M" wrote:

This is a "sub datasheet" that is being seen in the TABLE by clicking on the
plus sign. If I create a new database like suggested how do I copy over all
the information from the tables?

As far as my original question about deleting a subdatasheet without loss of
data, by changing the properities to none will that solve my problem. I have
to end up with a new file to be imported into a different kind of program,
but I have to keep all the records including any history that has been kept.

"Rick B" wrote:

Is this a "subform" that is being viewed in a FORM as you have said, or a
"sub datasheet" that is being seen in the TABLE view by clicking the plus
sign to the left of the record? They are very different things.

In answer to your question, you say you want to create a new database with
only some of the data. Why not just create a new database and copy over the
tables with the data you want?

Your original question says you want to delete the subform (I'll assume you
mean subdatasheet) but keep the data. Why do you care if there is a
subdatasheet? You should not be in the tables. Once you build your
database structure, you should not go into the tables again. You should be
using forms, reports, and queries for all your user interface. Don't worry
about the subdatasheet. If you must get rid of it, Open your TABLE in
design-view, go to the PROPERTIES box and change the Subdatasheet Name to
[none].


--
Rick B



"Carol M" wrote in message
...
What I'm trying to do is build a new database from old information, but I
have to leave out certain information. How can I find out what table my
subform is looking at short of viewing the relationships? When I delete a
subform it is after I have collapsed in back. As you might have guessed I
am
new to this kind of form and that is why I am asking for help.
Thank you,
Carol M

"John Vinson" wrote:

On Wed, 3 Aug 2005 08:38:42 -0700, "Carol M"
wrote:

The problem I have is that it does delete the stored data. My customer
database is linked to a customer category database which is the
subform. Upon
deleting it, it also deletes the required information to create the new
database.

This isn't making sense, Carol.

As Bruce correctly says, the Subform doesn't contain any data. It
doesn't contain "the information needed to create the new database". A
subform (like any form) is *just a window* - a tool used to view and
edit data stored in Tables. The customer database IS NOT THE SUBFORM -
the subform is used to view and edit the customer database; but it is
no more the database than my office window is the Owyhee Mountain
range.

Are you deleting a Subform in Forms Design view? Or are you deleting a
Table? Could you explain how you're determining that it "deletes the
required information"? Just how are you deleting it?

John W. Vinson[MVP]