Form/SubForm with a SubForm

  • Thread starter Thread starter tonyaims
  • Start date Start date
T

tonyaims

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,

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

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
Click to expand...
.
Click to expand...
 
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.
 
Back
Top