Controlling subform data with a combo box on the main form

[klnlsu]

I have created a form that displays a single Process Code record on a form. I use a combo box to select the Process Code ID I want to display. I have placed a subform on the main form that displays all inventory items that have the Process Code. The problem is that this is only working if I select the first Process Code record (probably because it chooses that record by default). If I choose any other Process Code record, the subform doesn't display anything. It has to be a problem with my link between the form and subform, because I can open the form, select any record, then open the subform separately, and the item records list properly. In the subform properties, I have the Link Master Fields property set to CodeID in the Process Code table that is the data source for the main form, and I have the Link Child Fields property set to CodeID in the query that is the data source for the subform and uses the Process Code table as its primary source of data. The combo box is unbound. If I try to assign the CodeID field as the control source for the combo, it will not let me select a Process Code record. It just beeps at me. Any suggestions? Need more info?

[June7]

Need to review code and/or query/forms design.

If you want to provide db for analysis, follow instructions at bottom of my post.

[klnlsu]

attached is zipped DB (I hope I did it right)

ProdSchd - Copy.zip

[June7]

The tables are links and since you did not provide the backend I cannot review table design and there is no data to test with. There are no Relationships set. I do not understand how data is related.

The form has 5 levels of nested forms. The most I've ever seen

Having a field in every table with the same name (CodeID) can be confusing.

[klnlsu]

Thanks for looking at this for me, but I'm afraid it was just a stupid mistake on my part. I made some revisions on my form and accidentally gave my key field a different name so my query wasn't finding it!