>Again part of the legacy system I'm changing, fopr some reason the author made a field that ellicits a Y/N answer C(1) and codes the original form to check for this, rather than making it logical. I want my new form to have a checkbox.
>
>Never come across this requirement before but I thought it would be achievable by putting the expression:
>
>=IIF( RteFam.Survey = "Y", .T., .F.)
>
>in the .Value property of the checkbox. It doesn't react at all. I tried:
>
>=IIF( RteFam.Survey = "Y", 1, 0)
>
>but that makes no difference either. Sure I know I can put code in a method to set the checkbox but I just wanted to do it simply, sans code.
>
>Why doesn't this work?
>
>'ppreciate it.
>
>Terry
Terry,
In the properties, try [ UPDATE, in the controlsource this is ]
(RteFam.Survey = 'Y')
Gregory