Hi,
I'm trying to VBA my way around the Access 97 restriction of 2 nested sub-forms.
Tables (actual names):
tblTopic -> tblSubTopic -> tblTitle -> tblSolution.
More realistically named for you:
Problem -> SubProb -> SProb_Titles -> SProb_Title_Solutions
The arrows indicate possible 1:many relationships. I can assure you that although the names may not indicate true 1:many - they are 1:many.
I've decided on a form with no data-source, with a 'Problem' combo that controls a 'SubProblem' combo (both on main form) which controls a SProblem_Title subform which controls a SProblem_Solution subform.
The Problem combo controls the SubProblem combo OK, which changes the subform (SProblem_Title) correctly for only one single related record. On all others - it changes the SProblem_Title record in the sub-form, but there is no correlation between records displayed in the SProblem_Title subform to the 'parent' subProblem combo (apart from one as mentioned above).
I have tried to use the subform container master/child properties to refer to keys, but have discarded this also (unbound forms) and am now attempting to control the subforms in code.
I know that this issue will be outside of the scope / experience of most Tek-Tippers, but if anyone can aim me at an example of this working (via whatever method, as long as it does not involve 3rd party add-ins) I would be most grateful.
I don't want this handing on a plate - just an indication of the direction to go.
Many thanks for any pointers,
Kind regards,
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
I'm trying to VBA my way around the Access 97 restriction of 2 nested sub-forms.
Tables (actual names):
tblTopic -> tblSubTopic -> tblTitle -> tblSolution.
More realistically named for you:
Problem -> SubProb -> SProb_Titles -> SProb_Title_Solutions
The arrows indicate possible 1:many relationships. I can assure you that although the names may not indicate true 1:many - they are 1:many.
I've decided on a form with no data-source, with a 'Problem' combo that controls a 'SubProblem' combo (both on main form) which controls a SProblem_Title subform which controls a SProblem_Solution subform.
The Problem combo controls the SubProblem combo OK, which changes the subform (SProblem_Title) correctly for only one single related record. On all others - it changes the SProblem_Title record in the sub-form, but there is no correlation between records displayed in the SProblem_Title subform to the 'parent' subProblem combo (apart from one as mentioned above).
I have tried to use the subform container master/child properties to refer to keys, but have discarded this also (unbound forms) and am now attempting to control the subforms in code.
I know that this issue will be outside of the scope / experience of most Tek-Tippers, but if anyone can aim me at an example of this working (via whatever method, as long as it does not involve 3rd party add-ins) I would be most grateful.
I don't want this handing on a plate - just an indication of the direction to go.
Many thanks for any pointers,
Kind regards,
Darrylle
Never argue with an idiot, he'll bring you down to his level - then beat you with experience.
