Choosing Criteria based on option Box Value

[todmac]

Hi All,


I have a query and I am trying to use an option group as a parameter.

I have used the formula

 =iif(forms![LookupForm].frame12.value = 1, "Vendor", "Manufacturer"

however I get the same results no matter which way I toggle the buttons (only vendors come up)
if I change it to

 =iif(forms![lookupform].frame12.value = 2, "Manufacturer", "Vendor"

then I only get the manufactures.

Any idea what I am doing wrong here?
Thanks,
Todd

[June7]

What controls are you putting in the frame - radio buttons?

[todmac]

Sorry. Yes, Radio Buttons.

[June7]

Your expression is missing closing ). Should get an error message. Is that just a typo in the post?

I never use dynamic parameterized query. I prefer VBA code to set filter of form or report.

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