I'm following a guide to link 2 subforms. Can't seem to post the link here but mdb is attached.
Aim is to have an outlook style 2 vertical forms next to each other.
One master subform on left is tasks list datasheet called keydates. On right is detail of the task that has focus.
The keydates form has a combobox called CaseName. This has 2 fields in the source query, (CaseID, CaseName). CaseID is bound field 1 but 0 width so hidden. Only CaseName field 2 is visible in the Combolist.
The detail subform on right needs to link using CaseID.
The guide explains that 2 subforms cannot link to each other.
I've created a txtbox called txtCaseID as per guide in the main form. This is linked to master subform by putting following in the txtbox control source.
Problem, is that txtCaseID only links to the CaseName combobox visible field (ie. 2nd field CaseName). I need to link to the CaseID field 1 which is not visible.
I've tried linking to
But this just return '1' as the bound column. I want the data inside the bound column 1.
Main form txtCaseID seems to link to CaseID bound field in CaseName combobox only when I add/amend new record in frmKeyDates. Otherwise it seems to links to the visible data in combobox CaseName (ie. column 2) instead.
Any advice on how to resolve this?
Thanks
Aim is to have an outlook style 2 vertical forms next to each other.
One master subform on left is tasks list datasheet called keydates. On right is detail of the task that has focus.
The keydates form has a combobox called CaseName. This has 2 fields in the source query, (CaseID, CaseName). CaseID is bound field 1 but 0 width so hidden. Only CaseName field 2 is visible in the Combolist.
The detail subform on right needs to link using CaseID.
The guide explains that 2 subforms cannot link to each other.
I've created a txtbox called txtCaseID as per guide in the main form. This is linked to master subform by putting following in the txtbox control source.
Code:
=[frmKeydates].[Form]![CaseName]
Problem, is that txtCaseID only links to the CaseName combobox visible field (ie. 2nd field CaseName). I need to link to the CaseID field 1 which is not visible.
I've tried linking to
Code:
[frmKeydates].Form![CaseName].BoundColumn
But this just return '1' as the bound column. I want the data inside the bound column 1.
Main form txtCaseID seems to link to CaseID bound field in CaseName combobox only when I add/amend new record in frmKeyDates. Otherwise it seems to links to the visible data in combobox CaseName (ie. column 2) instead.
Any advice on how to resolve this?
Thanks
Attachments
Last edited: