Checkbox problem

[Newboy]

I am having problems trying to get a checkbox on a form
to work as I wanted.
The idea was that if a date had been entered in a field
in a table then the checkbox on the form show as ticked
so I set the Control Source to:
"=IIf((AgreementsTrial!REPORT_YEAR>""),True,False)"
but the If won't seem to allow me to do the test

 

[Steve Schapel]

Newboy,

There are a few problems with this. First, if
AgreementsTrial!REPORT_YEAR is supposed to refer to "a field in a
table", then this is incorrect syntax, and doesn't really make sense.
Even if it was correct, you couldn't use it in an expression such as an
IIf function where you are trying to evaluate it, because Access would
need to know which record in the AgreementsTrial table you are referring
to. If there is only one record in the table, maybe you mean something
more like this...
=DLookup("[REPORT_YEAR]","AgreementsTrial") Is Not Null
Otherwise, could you post back with some further information about what
you are trying to do?