Calling tables within a calculated field

[TonyB]

Hi,

I'm sure this is really simple, but it's just not working for me. To call data from within a form, I can use [forms]![form_name]![field_name] in the control source.
However, if I try the same format with table data (i.e. [tables]![table_name]![field_name]) then it doesn't work as Access can't find the table.



All I want to do in my report is replace a checkbox with a text field that says "Yes" if the table the box is checked and "No" if it's unchecked:

=IIf([table]![tblReqLogs]![Completed]="-1","Yes","No")


Thanks

[RuralGuy]

In Access in order to look at tables you need to use either a Recordset or a Domain function (DLookup...)

[TonyB]

Is that used in Access SQL queries? I thought DLookup was VBA?

[TonyB]

(ignore my last post)

[RuralGuy]

BTW, a Checkbox field is either 0 (false) or -1 (true). It is a numerical value not a string value ("-1") Actually technically a Checkbox field could also be Null.