checkbox control source fails

[AlexanderBB]

I have a query which tests OK in query design, but when I use this as the control source for a check box
I get

Run-time error '2424':
The expression you entered has a field, control, or property name that Microsoft Office Access can't find.

I've tried with and without quotes around the query. Same error.

The query text is

"SELECT Table1.Task, Table1.Client FROM Table1 WHERE (((Table1.Task)='User'));"

Table1.Client is a Yes/No field.

 

[xenou]

Hi,

There are two ways to interpret your question.

If the query is part of the form datasource and you have bound fields, then you would only need to drag the field into the form from the fields dialog.

Otherwise, I would think if you want this to be a control source for a checkbox but it is not part of a form record source, it would need to be a query that returns a single record with a single value (yes or no).

 

[AlexanderBB]

Hi Xenou

>returns a single record with a single value

Ahh.. yess, that's gotta be it! I somehow fell into a trap.
Thanks for putting me straight!

Rgds, ABB