Access 2010 - Parent form not seeing Child combo box

[ceeunderstanding77]

Hello!

I've setup a form with 2 combo boxes: "Screen Type" and "Garment Type", that are populated based on the value selected in the "Operation Code" combo box.

This works fine until I add this onto a parent form.

The parent form has a drop down box "Grid Number" to filter for matches on the child form.

The Issue is I receive a "Enter Parameter Value" input box on the Parent form when I click the combo boxes on the Child form for the "Screen Type" or "Garment Type" combo boxes. It's like the parent can't see the OperationCode value in the child form.

The two forms are linked by the parent's cmbGridNumber to the child's GridNumber field.


How do I get around this (Screen shot attached)?

Here's the sql that builds the list in the "Garment Type" combo box -



SELECT dbo_LOOKUP_OperationCode.GarmentType
FROM dbo_LOOKUP_OperationCode
WHERE (((dbo_LOOKUP_OperationCode.OperationCode)=Forms![AMPS Maintenance Detail]!OperationCode))
GROUP BY dbo_LOOKUP_OperationCode.GarmentType
ORDER BY dbo_LOOKUP_OperationCode.GarmentType;

 

[ceeunderstanding77]

The Access db is attached

 

[JHB]

Is this what you where looking for?

 

[ceeunderstanding77]

Is this what you where looking for?

You are the mf'n man JHB! TH.ANHKS!!!

This is precisely what I was looking for. It appears the issue was with the way the SQL was setup to load the combo boxes. I'm going to study this.

Thanks again!!!

 

[JHB]

You're welcome - good luck.