I didn't have the checkbox set to be triple-state...once I did that and
selected the proper control source on the form everything worked out nicely!
I didn't want to start a new thread as this seems to have been the final
answer. Thank you and to all that assisted and it sure is nice to see you
pounce out those preditors that try to take advantage of others like me when
we are vulnerable! Cheers

"John Spencer MVP" wrote:

Did you add the checkbox to the form?
Is the checkbox bound to any field? It should not be bound to any field or to
any calculation.

Check that the control's Locked property is NO and Enabled property is Yes.

What do you want to happen if the checkbox is not checked? Do you want all
the records or just records where the the value of the field is false?

If you have set the checkbox up to be a triple-state checkbox then it can be
checked (true), unchecked (false), or grayed out (Null)?

If you use a triple-state checkbox on your criteria form, the criteria in the
query would be something like the following to show just the owned or just the
not owned or ALL the records. Triple-State property is found on the Data tab.

Field: Owned
Criteria: Forms![frmReportDue]![NameofCheckboxControl] or
Forms![frmReportDue]![NameofCheckboxControl] is null

You might try opening a new thread with just the problem you are having.
That, hopefully will get you away from all the extraneous comments that are
attached to this thread.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hedwig14 wrote:
Can someone answer my question as to why the checkbox is not editable when I
add the Owned field into the query and report?

"Keith Wilby" wrote:

"Steve" moron_available_at_very_reasonable_rates@contactm e.com wrote in
message ...
Once again you got a response from the IGNORANT stalker!
Yes, and that stalker is YOU.