Combine/Merge Several Forms into one Form

[RichW]

I have several forms that are identical in structure, but display different
data; these forms are named frmGoals1, frmGoals2, and so on.

I also have a form that has check boxes tied to each of the above named
forms. A user selects the forms he/she wishes to review then clicks a
command button. The forms are then displayed.

I wish to learn if it is possible to have all "selected" forms merge into a
single form; each form would retain its structure and data but be combined
into a single form.

Please advise.

 

[Douglas J. Steele]

Forms are strictly windows to data.

If you already have a form, all you need do is change the RecordSource for
the form. Create a query that UNIONs the various tables together, and set
the form's RecordSource to the name of that query. Of course, a UNION query
is not updatable. If you need to be able to update data, you're going to be
out of luck.

 

[RichW]

Doug, thanks for such a quick and informative reply. Unfortunately, the
information basically shelves my first intent of being able to update the
data.

With my previous message in mind, would I be able to have all "selected"
forms merge into a single report?

Thanks again,
Rich

 

[Douglas J. Steele]

Previously you asked about merging selected forms into a single form: now
you're asking about a single report.

If you really meant single form, the answer's no (unless each of the
separate forms are drawing data from the same table).

if you did mean single report, I'm not sure what the issue is, since reports
aren't intended to be used for updating.

 

[RichW]

Doug, yes, you are correct.

My first message asked if it was possible to merge selected forms into a
single form. In response, you advised that this was not possible if I
planned to update that data.

Your response caused me to wonder if it would be better to merge selected
forms into a report, instead of a single form. Updating would still not be
possible, but the database may be a bit cleaner?

Your comments would be appreciated.

Thank you,
Rich

 

[Douglas J. Steele]

You'd be best off having a query that returned all the records of interest
(which means a UNION query if the data's in multiple tables) and use that
query as the RecordSource for a single report.

Yours sounds like a fairly unusual requirement, and suggests to me that your
database may not be designed optimally.