combo boxes in subform fail to perform

[eapinto]

Hello all,

I need help with the subform I've created and placed in to a main form.
the subform in question contains 2 combo boxes. these cbo's are related to each other in that when selecting an item from the first cbo the second cbo only gives the items related to the selected item.
The combo boxes work fine as a standalone form. My problems is that when I place the information as a subform it takes me to a "enter parameter value" pop up. The criteria that I have used in the query for the combo boxes when in stand alone form is
[Forms]![frmSOP1]![SOPDepartmentID]

I have tried most of the combination to try to get the combo boxes to work in subform but I'm getting nowhere.
The main form name is frmPersonnelMain the query that I use to "tie" the combo boxes is

SELECT tblDepartment.[Department ID], tblSOP1.[SOP Name]
FROM tblDepartment INNER JOIN tblSOP1 ON tblDepartment.[Department ID] =
tblSOP1.[Department ID]
WHERE (((tblDepartment.[Department ID])=[Forms]![frmSOP1]![SOPDepartmentID]));

I'm very inexperienced in Access and it takes me forever to get it to do what I need.

Any help would be really appreciated. I don't know where to go to next.

 

[BamaBraves]

Are both combo's on the subform or one is on the main form and the other in the subform?

I would also remove any spaces in the field names. That way you don't have to worry about quote marks.