Display True, False, or "All" records in a continuous form

[ragtopcaddy via AccessMonster.com]

I'm sure this is a common question, but I can't seem to phrase it right to
find the answer.

I have an option group in the header of my form called "grpFloat". I want to
display records in this continous form that reflect selections in the option
group. If I had left it at True or False, no problem. But if I select "All" I
don't know how to set the underlying query field's criteria to return the
right records.

This doesn't work ("...too long to be evaluated...") as the criteria for the
"Float" field in the form's query, but it might give you some idea of what
I'm trying to do:

IIf([Forms]![frmDfltHCs]![grpFloat]=9999,"*",[Forms]![frmDfltHCs]![grpFloat])

Thanks,

Bill R

 

[Klatuu]

Try it like this:

Like
IIf([Forms]![frmDfltHCs]![grpFloat]=9999,"*",[Forms]![frmDfltHCs]![grpFloat])

 

[ragtopcaddy via AccessMonster.com]

Got it! Thanks again.

Bill R

Barada nikto

Try it like this:

Like
IIf([Forms]![frmDfltHCs]![grpFloat]=9999,"*",[Forms]![frmDfltHCs]![grpFloat])

I'm sure this is a common question, but I can't seem to phrase it right to
find the answer.

[quoted text clipped - 14 lines]

Bill R