Form/SubForm with a SubForm

I have a project table, a change order(CO) table and a
change order notes table. Typically, a project has
multiple COs and each CO has a number of notes. I need to
develop a form that displays:
1. General Project Info(frmProject) - the main form
2. All COs for the project(frmChangeOrders) - CO sub form
3. All notes for each CO(frmChangeOrderNotes) - Notes sub
form

I would like to have a project form with a spreadsheet
type sub-form to display the COs for the selected project.
I would like to have a Notes button on the form. If the
user clicks on the Notes button, all Notes for the
selected CO will be displayed one at a time in a text box
like format

Can this be done? How?

Thanks,

Tony

Tony,

One approach to this would be to put both frmChangeOrders form and
frmChangeOrderNotes form as subforms on frmProject form. Then, set the
LinkMasterFields property of the frmChangeOrderNotes subform to point to
the CO primary key field, for example [frmChangeOrders].[Form]![CO_ID].
This way, you wouldn't need a command button on the form, the Notes
will automatically be shown for the selected CO record.

--
Steve Schapel, Microsoft Access MVP


tonyaims wrote:
I have a project table, a change order(CO) table and a
change order notes table. Typically, a project has
multiple COs and each CO has a number of notes. I need to
develop a form that displays:
1. General Project Info(frmProject) - the main form
2. All COs for the project(frmChangeOrders) - CO sub form
3. All notes for each CO(frmChangeOrderNotes) - Notes sub
form

I would like to have a project form with a spreadsheet
type sub-form to display the COs for the selected project.
I would like to have a Notes button on the form. If the
user clicks on the Notes button, all Notes for the
selected CO will be displayed one at a time in a text box
like format

Can this be done? How?

Thanks,

Tony

Steve,

How do you put 2 forms as subforms onto a third form?

Thanks for your help,

Tony

-----Original Message-----
Tony,

One approach to this would be to put both frmChangeOrders
form and
frmChangeOrderNotes form as subforms on frmProject form.
Then, set the
LinkMasterFields property of the frmChangeOrderNotes
subform to point to
the CO primary key field, for example [frmChangeOrders].
[Form]![CO_ID].
This way, you wouldn't need a command button on the
form, the Notes
will automatically be shown for the selected CO record.

--
Steve Schapel, Microsoft Access MVP


tonyaims wrote:
I have a project table, a change order(CO) table and a
change order notes table. Typically, a project has
multiple COs and each CO has a number of notes. I need
to
develop a form that displays:
1. General Project Info(frmProject) - the main form
2. All COs for the project(frmChangeOrders) - CO sub
form
3. All notes for each CO(frmChangeOrderNotes) - Notes
sub
form

I would like to have a project form with a spreadsheet
type sub-form to display the COs for the selected
project.
I would like to have a Notes button on the form. If the
user clicks on the Notes button, all Notes for the
selected CO will be displayed one at a time in a text
box
like format

Can this be done? How?

Thanks,

Tony
.

Tony,

The method I generally use to put a subform on a main form, is to
arrange my screen display so that I can see the design view of the main
form, and also the Database Window, at the same time. And then, in the
Database Window find the name of the form you want to use as the
subform, and just drag it from the Database Window and drop it in the
main form. If you want two subforms, just do this process twice! Then,
you need to make sure you have the Link Master Fields and Link Child
Fields properties of the subforms set up correctly.

--
Steve Schapel, Microsoft Access MVP


Tonyaims wrote:
Steve,

How do you put 2 forms as subforms onto a third form?

Thanks for your help,

Tony