Stmt works for cbo on subform but not parent form

[KerryL]

On a customer order form I have a subform which contains the order details information, and I use a "limit-to-list" statement to narrow the choices of cbo #2 based on what is selected in cbo #1.

Table = tblProducts
CBO #1 = cboDivision
CBO #2 = cboProjDescr
SubForm = sfrmRequestDetails
Parent Form = frmCustRequests

The select statement for cboProjDescr is:
SELECT [tblProducts].[ProjectDescr] FROM tblProducts WHERE ((([tblProducts].[DivisionName])=[Forms]![sfrmRequestDetails]![cboDivision])) ORDER BY [tblProducts].[ProjectDescr];

It works fine when I test it within the subform, but when I test it by opening the parent form I am prompted to enter a value for cboDivision even though I've already selected something from the list.

Do I need to qualify my select statement differently because the subform resides in a parent form? Or is there something else I'm not considering?

Thanks in advance,
KerryL

 

[TerpFan2001]

Kerry:

You won't be able to directly reference the control on the subform from the parent form.

Try changing the way you reference the control on the subform from:

[Forms]![sfrmRequestDetails]![cboDivision]

to:

[Forms]![Name of Parent Form]![Name of Subform Control on Parent Form].Form![cboDivision]