Linked combo box in subform

S

Shannon

One final question (Thanks to everyone who has helped me thus far)

My subform (a datasheet) now will accept the cascading combo boxes (though
the form only displays the sub ingredients of whatever ingredient it is that
is of the record I have selected, but that's not a huge deal)
The problem is that the combo boxes done with
[forms]![subformname]![combobox1]. So they don't work in the normal form.
I can't select and I can't see what's already selected.
I tried changing the form to the main form name but that doesn't help.
 
J

John Vinson

One final question (Thanks to everyone who has helped me thus far)

My subform (a datasheet) now will accept the cascading combo boxes (though
the form only displays the sub ingredients of whatever ingredient it is that
is of the record I have selected, but that's not a huge deal)
The problem is that the combo boxes done with
[forms]![subformname]![combobox1]. So they don't work in the normal form.
I can't select and I can't see what's already selected.
I tried changing the form to the main form name but that doesn't help.
Click to expand...

To reference a control on a subform you must go via the main form: the
Name property of the form you're using as a subform is irrelevant,
what you need is the Name property of the subform *control* on the
mainform. Use a criterion of

=[Forms]![mainform]![subformcontrol].Form![combobox1]


John W. Vinson[MVP]
 
Top