I have a main form with some property info that contains one continuous subform. This subform is called "frmProjectSubform" and it contains a list of projects for that property.
Now I want to add a second continuous subform "frmProjectHistorySubform" next to the first one to show the history comments for any one selected project.
What I want to do is simply click (or doubleclick) on any project listed in subform "frmProjects" and have the subform "frmProjectHistorySubform" update to that project's history comments to read them or edit them or even enter new ones.
The table relationships are worked out through the recorsource tables (tblProperties for the main form, tblProject for the first continuous subform and tblProjectHistory for the second subform)
What needs to be done to update the data in "frmProjectHistorySubform" when I click on a project in "frmProjectSubform"?
Thanks
mafhobb
Now I want to add a second continuous subform "frmProjectHistorySubform" next to the first one to show the history comments for any one selected project.
What I want to do is simply click (or doubleclick) on any project listed in subform "frmProjects" and have the subform "frmProjectHistorySubform" update to that project's history comments to read them or edit them or even enter new ones.
The table relationships are worked out through the recorsource tables (tblProperties for the main form, tblProject for the first continuous subform and tblProjectHistory for the second subform)
What needs to be done to update the data in "frmProjectHistorySubform" when I click on a project in "frmProjectSubform"?
Thanks
mafhobb