Hopefully somebody can tell me what the heck I'm doing wrong..
On my main form I have a combo Box named section, pulling all my sections in, using qrysection. It is the only field in this query. On my subform I have a combo box named employee, that is supposed to filter all employess that relate are the section I select in my main form. The subforms combo box is based off the qryEmployee which contains the fields, Employee ID, Name(Lname+FName) and section . The critera for the section field is [Forms]![frmSummaryMain]![Section.
I'm getting nothing much to happen. When I the combo on the subform form drops down it contains names, but names not related to section above.
Any help would be appreciated. Let me know if I need to supply more info
Mike
On my main form I have a combo Box named section, pulling all my sections in, using qrysection. It is the only field in this query. On my subform I have a combo box named employee, that is supposed to filter all employess that relate are the section I select in my main form. The subforms combo box is based off the qryEmployee which contains the fields, Employee ID, Name(Lname+FName) and section . The critera for the section field is [Forms]![frmSummaryMain]
