Enable or Disable Checkbox with expression builder

[Kaushik]

Hi ,

Is that possible for me to enable or disable any control using iif
condition from the control source of a control in a access form?

Let me explain the problem. I have an Access form whose record source is a
SQL Query. The form have several Check boxes whose control source are
different fields from the query used in record source. This is very normal.
Now I have to enable or disable each check box depending upon a fild value
say "objnumber" which is also coming from the record source query. How can I
do that. I tried writing expresion in the control source property of each
check box with Expression Builder like -
iif(objnumber="16",chkCheckBox1.enabled="false",chkCheckBox1.enabled="true")
but that does not help more over I have to show the query field data also in
the checkbox.

Please help me
Thanks and Regards
Kaushik

 

[Klatuu]

Already answered in another post.
Please note that cross posting is frowned upon.

 

[Jeff Boyce]

Already responded to in another newsgroup.

It's rarely necessary to post the same issue to more than one group. But if
you feel you must, please use the "To:/Newsgroups:" section to list all
groups one time. That way, the volunteers who help out here don't waste
their time answering a question that was already answered in another
newsgroup (posting this way lets an answer in one ripple to the others).

Plus, you don't have to look all over to see if there's been an answer!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/