Dear members of the board,
I ‘m having trouble with cascading combo boxes in a subform (frmEvaluaties, subform named “fsubEvaluaties” in frmMJPs). I have a second combobox (cboStandaardzinnen) based on a query (tlkpStandaardzinnen) with a field criterium referring to the first combobox (cboIDcriterium). Probably I use wrong addressing of the subform control, but I can’t find out how (probably some detail I overlook…)
The query SQL is:
SELECT tlkpStandaardzinnen.*
FROM tlkpStandaardzinnen
WHERE (((tlkpStandaardzinnen.sz_Criterium)=PARAMETER));
With PARAMETER = [Forms]![frmEvaluaties]![cboIDcriterium]
it works OK when opening the subform as a form.
When using frmEvaluaties as a subform
= [Forms]![frmMJPs]![fsubEvaluaties]![form]![cboIDcriterium]
it won’t work.
I’ve included it as attachment.
Can anyone see what I’m doing wrong?
TIA!
Hasse
[Forms]![frmMJPs]![fsubEvaluaties]![form]![cboIDcriterium]
