Checkbox doesn't check in the form


G

Guest

I have a form that is built using a query. All of the fields on the form are
disabled with the exception of one checkbox, that should allow the user to
click and check the box if they approve. However, nothing happens when I
click the check box. Since the field is enabled, what should I do to make
the field clickable so that it updates the table?

Thanks,
Amy
 
Ad

Advertisements

G

Guest

If the Enabled property of the check box is set the Yes and the Locked
property is set to No, then check these two things:

AllowEdits should be Yes
Be sure the recordset is updatable.
 
R

Rick Brandt

Amy said:
I have a form that is built using a query. All of the fields on the form are
disabled with the exception of one checkbox, that should allow the user to
click and check the box if they approve. However, nothing happens when I
click the check box. Since the field is enabled, what should I do to make
the field clickable so that it updates the table?
My guess is that your query is producing a non-editable result set. Try to make
an edit directly in the query datasheet and see if you can.
 
G

Guest

Thanks Klatuu! I was able to check the form properties and the AllowEdits is
set to yes and the recordset is set to dynaset. However, I still can not
update the checkbox.
 
G

Guest

Thanks Rick! You are right! I can not edit in the query datasheet. How do
I make the one field editable? Also, once the checkbox can be checked, how
do I make the update to the original table? Thanks for your help!

Amy
 
R

Rick Brandt

Amy said:
Thanks Rick! You are right! I can not edit in the query datasheet. How do
I make the one field editable? Also, once the checkbox can be checked, how
do I make the update to the original table? Thanks for your help!
There is a help topic named "When can I update data in a query" that you need to
read. There are numerous reasons why a query will not be editable and the
reason varies from one query to the next.

If you don't know why your query is not editable after reading that help article
post the SQL of the query here and someone might be able to suggest changes that
would allow edits.

Once the query is editable then your change to the form will automatically be
saved to the table.
 
Ad

Advertisements

G

Guest

Thanks Rick! I wasn't able to find the help topic, but I was able to figure
out why the form was not editable! Thanks again!
 

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