B
Brad
I'm having trouble getting my cascading combo box to work on my subform. I
know this is due to how I reference the controls on the subform from the main
form. Just not sure how to tie it all together. Title of main form is
CurrentDate. Title of subform is Loop3_Subform. There are 2 combo boxes on
Loop3_Subform (Model and Row) that feed a third (Issue). I have a requery
statement on the after update of Model and Row and here is what i have the
rowsource data for Issue set as:
SELECT Issues.IssueID, Issues.Issue, Issues.Model, Issues.Row FROM Issues
WHERE (((Issues.Model)=Forms!Loop3_Subform!Model) And
((Issues.Row)=Forms!Loop3_Subform!Row));
Any help on how to make this work on main form will be greatly appreciated.
know this is due to how I reference the controls on the subform from the main
form. Just not sure how to tie it all together. Title of main form is
CurrentDate. Title of subform is Loop3_Subform. There are 2 combo boxes on
Loop3_Subform (Model and Row) that feed a third (Issue). I have a requery
statement on the after update of Model and Row and here is what i have the
rowsource data for Issue set as:
SELECT Issues.IssueID, Issues.Issue, Issues.Model, Issues.Row FROM Issues
WHERE (((Issues.Model)=Forms!Loop3_Subform!Model) And
((Issues.Row)=Forms!Loop3_Subform!Row));
Any help on how to make this work on main form will be greatly appreciated.