Form Subform data export

  • Thread starter Thread starter iam
  • Start date Start date
I

iam

I have created what I thought was a very simple form that hold about
15 field of data.

One of those fields is a subform that holds multiple entried based on
the specific record number.

I am trying to export the table to WORD in order to create a catalog.

I am using merge inside of Word.

The items from the primary table come through just fine. The items on
the subform table don't come through at all.

Easy solution?
 
I have created what I thought was a very simple form that hold about
15 field of data.
Click to expand...

Forms don't hold data, any more than my office window "holds" the
Owyhee Mountains. A form is just a tool to allow you to enter data
into a Table.
One of those fields is a subform that holds multiple entried based on
the specific record number.
Click to expand...

And a Subform isn't a field. It's another form.
I am trying to export the table to WORD in order to create a catalog.

I am using merge inside of Word.

The items from the primary table come through just fine. The items on
the subform table don't come through at all.

Easy solution?
Click to expand...

Export from a Query joining the main table (which is updated by the
main form) and the related table (which is updated by the subform),
and export from that Query rather than from either table.

John W. Vinson[MVP]
 
Export from a Query joining the main table (which is updated by the
main form) and the related table (which is updated by the subform),
and export from that Query rather than from either table.

John W. Vinson[MVP]
Click to expand...

When I tried that join I got multiple copies of the same record
depending on the number of entries in the subform.

Record 1

Field1 Field2 Field3 Field4 Subform Field Entry 1
Field1 Field2 Field3 Field4 Subform Field Entry 2
Field1 Field2 Field3 Field4 Subform Field Entry 3
Field1 Field2 Field3 Field4 Subform Field Entry 4
Field1 Field2 Field3 Field4 Subform Field Entry 5
Field1 Field2 Field3 Field4 Subform Field Entry 6

Record 2

Field1 Field2 Field3 Field4 Subform Field Entry 1
Field1 Field2 Field3 Field4 Subform Field Entry 2
Field1 Field2 Field3 Field4 Subform Field Entry 3
Field1 Field2 Field3 Field4 Subform Field Entry 4
Field1 Field2 Field3 Field4 Subform Field Entry 5
Field1 Field2 Field3 Field4 Subform Field Entry 6

When what I am trying to achieve is:

Record 1

Field1
Field2
Field3
Field4
Subform Entry 1
Subform Entry 2
Subform Entry 3
Subform Entry 4
Subform Entry 5
Subform Entry 6

Record 2

Field
Field
Field
Field
Subform Entry 1
Subform Entry 2
Subform Entry 3
Subform Entry 4
Subform Entry 5
Subform Entry 6
 
When what I am trying to achieve is:

Record 1

Field1
Field2
Field3
Field4
Subform Entry 1
Subform Entry 2
Click to expand...

You can't do that in a Query; you should be able to create a Report
and export that Report to Word (as a .rtf file). Use the report's
Sorting and Grouping to put the main table fields in the group header
and the subform data in the detail section.

John W. Vinson[MVP]
 
You can't do that in a Query; you should be able to create a Report
and export that Report to Word (as a .rtf file). Use the report's
Sorting and Grouping to put the main table fields in the group header
and the subform data in the detail section.

John W. Vinson[MVP]
Click to expand...

Well, Ill try that.....when I tried to export a report with the
subform as part of the report detail it choked and said I could not do
that. I did not try grouping though....I'll let you know.
 
You can't do that in a Query; you should be able to create a Report
and export that Report to Word (as a .rtf file). Use the report's
Sorting and Grouping to put the main table fields in the group header
and the subform data in the detail section.

John W. Vinson[MVP]
Click to expand...

Haven't worked with reports much so I figured I HAD to use the subform

to display the data like on the form. Learn something new again.

Building the report in Report Wizard facilitates the grouping you
referred to so I was able to build a basic form and then rearrange
things the way I wanted them to transfer.

Now what can I do for you.
 
Now what can I do for you.
Click to expand...

Pass it on - help somebody else on a volunteer basis. I'll leave it up
to you who and how!

Glad I was able to help.

John W. Vinson[MVP]
 
Back
Top