Filter Combox on Subform Value from another

[deadelvis]

I ve searched these forums but cant for the life of me find the answer althought there are a lot of posts on combo box filters.

I have MainForm based on tblStaff. I have SubForm based on tblTimesheet.

They are linked by StaffID.

The user selects a Project from ProjectID in the Subform which is filtered to only show Projects assigned to that user. This is done by filtering the combo box by StaffID from the MainForm. Works no problem.

The problem i have is in the next combobox which displays the potential activities for the user. As there are about 80 potential activities i want to filter this based on the Project Role. There are only 5 project roles. I can refer to the project role in either the SubForm query or the ProjectID combobox query but it doesnt work.

I hope this is coherent. Could anyone suggest some code or query parameters for this!?? I'm not an idiot but im beginning to wonder.

Thanks in advance

 

[seth_belgium]

Try referring to the field on the subform (to the control's name) instead of referring to the field in the query the subform's based on.

Seth