Using a combo box from main form to filter in a function

[tareyj8569]

I have the below code, which is working (thanks to help from here) but I have a different question.



=Sum(IIf([Pass or Fail]="Pass" And [Pay Period]="02" And [Location]="Purple",1,0))/IIf(Sum(IIf([Pay Period]="02" And [Location]="Purple",1,0)) = 0, 1, Sum(IIf([Pay Period]="02" And [Location]="Purple",1,0)))

For [Pay Period] ="02" is there a way to make it filter by a combo box from the Mainform? This code is on a Subform the combo box is on a Mainform

Forms![Overview_]![Combo35] <the path for the combo box.

I tried inserting it where the 02 was but it just returns 0 and if I remove the "" it will error the whole thing out. Same if I try to just remove the [Pay Period]="02" and replace it fully it errors out.

Maybe I am asking for too much of access I am not sure but I do appreciate you taking the time to read and help.

[tareyj8569]

To try and simplify without so much there I am just trying to as =Sum(IIf([Pass or Fail]="Pass" And [Pay Period]="02" And [Location]="Purple",1,0)) and leaving the rest off to see if I can just get it to work like this.

=Sum(IIf([Pass or Fail]="Pass" And [Pay Period]=Forms![Overview_]![Combo35] And [Location]="Purple",1,0))
=Sum(IIf([Pass or Fail]="Pass" And [Pay Period]="Forms![Overview_]![Combo35]" And [Location]="Purple",1,0))
=Sum(IIf([Pass or Fail]="Pass" And Forms![Overview_]![Combo35] And [Location]="Purple",1,0))
=Sum(IIf([Pass or Fail]="Pass" And [Forms!][Overview_]![Combo35] And [Location]="Purple",1,0))

None of the above worked. - wanted to show what I have tried

[JamesDeckert]

try referencing the main form from the subform like this
me.parent![Combo35]

[tareyj8569]

Same thing=/ just 0 if I put in between " " and errors everywhere if I leave off " "

[JamesDeckert]

do not put between quotes. show the line that you're getting an error on.
if you leave out the "And me.parent![Combo35]", then you don't get an error, but putting it in gives you an error?
what is contained in the combo box?
maybe you need a cbool(me.parent![Combo35]) to convert it to boolean

[tareyj8569]

I am going to mark this as solved.
I ended up putting the requirement in the query and took it out of the function.
Thanks for your time and help