>>>>>>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')
>>>>>

>>>>
>>>>Thank you, Gregory
>>>>
>>>>I assume you mean in the .value property (if not, which else?)
>>>
>>>In the ControlSource of the checkbox !! (see UPDATE above)
>>>
>>>>I did that and got Data Type mismatch error. This is strange as the expression SHOULD yield T/F.
>>
>>Yes, thanks, that worked. BTW, the above error didn't happen when I put:
>>
>>= (RteFam.Survey = 'Y')
>>
>>That's all well and good. Trouble is, this is sort of contradicting the actual target control source, which is Y/N, not a logical. The form is has a grid page and details page. If I select a record that turns the checkbox on, then use the grid page to select another where the reord val = "N", then return to the details page, the previous F value still shows in the checkbox.
>
>Terry,
>
>I would say that in the details' page activate, you have to put: =m.this.Refresh()

Thank you. Do you not see my point, though that this is not specifying a controlsource, rather just saying it is logical, which it is not?

In any account, I've decided to set it via code, in my form's "next record" bespoke methos, in which I do other stuff anyway.

Thanks for your attention

Terry