combo boxes in subforms take 2

[Robbie]

I have three combo boxes that run off each other depending
on the selection of the first combo [Forms!FormaName!
ComboBox] which works fine in a stand alone form but as
soon as it's in a subform it doesn't seem to respond.
I have tried changing the references to Me.combobox but
i'm still having problems. this is my sql. where do I have
to insert the ME.Combobox, I have tried various places
with no success.

SELECT Tbl_CUSTLDDNLD.[Stan Pack], Tbl_CUSTLDDNLD.[Chilled
Ref]
FROM Tbl_CUSTLDDNLD
GROUP BY Tbl_CUSTLDDNLD.[Stan Pack], Tbl_CUSTLDDNLD.
[Chilled Ref]
HAVING (((Tbl_CUSTLDDNLD.[Chilled Ref])=[Forms]!
[tbl_tsfr_input_2 Subform]![combo52]));

many thanks


Robbie

 

[Nikos Yannacopoulos]

Robbie,

That's because the reference for combo52 needs to account for the fact that
the subform is on a particular form, so Access knows where to look. Since
the combo lives in a subform in a form, the reference to it should be
something along the lines of:

Forms![MainFormName]![tbl_tsfr_input_2 Subform]![combo52]

HTH,
Nikos