Here is my problem. I am trying to filter a combobox on a subform based on a combobox on my main form. I am successfully able to do this with two combo boxes on the same mainform but not with one on the mainform and one on the subform. I have attached a sample database with the tables, queries, and forms associated with this issue.
I would greatly appreciate some help on this issue. I have read numerous topics on this site relating to this topic and I have tried all the responses but I just keeping getting lost in the middle of the code.
Thank you in advance to all takers.
Sean