Check Box Control not activated when used in Query?

A

Andrew

I have a form that is based on a query in which check boxes must be checked
by reviewers in order to clear or filter on to other users. My problem is
that the Control Boxes will not work on the form (as if they are not
activated or usable). Could this be because the form is based on a query
instead of the actual table where the check boxes are?
 
M

Maarkr

I have a form that is based on a query in which check boxes must be checked
by reviewers in order to clear or filter on to other users.
I'm not gettting it... if you are checking off check boxes, are they shown
as checked in the query view after you update it? If you update data in your
form, does it show in all tables in the query?
Control Boxes will not work on the form (as if they are not activated or usable).
Do you mean you filter the form using Combo boxes? or do you update the form
after the check boxes are selected? pls explain 'control box'
 
J

John W. Vinson

I have a form that is based on a query in which check boxes must be checked
by reviewers in order to clear or filter on to other users. My problem is
that the Control Boxes will not work on the form (as if they are not
activated or usable). Could this be because the form is based on a query
instead of the actual table where the check boxes are?

It depends on the Query. Some queries can be updated, some cannot.

If you open the Query directly is it updateable?
What is the Control Source of the checkbox?
Could you post the SQL view of the query?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top