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

  • Thread starter Thread starter ragtopcaddy via AccessMonster.com
  • Start date Start date
R

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

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via AccessMonster.com
 
Try it like this:

Like
IIf([Forms]![frmDfltHCs]![grpFloat]=9999,"*",[Forms]![frmDfltHCs]![grpFloat])
 
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.
Click to expand...
[quoted text clipped - 14 lines]
Bill R
Click to expand...
Click to expand...

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via AccessMonster.com
 
Back
Top