Checkbox doesn't check in the form

[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

 

[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.

 

[Rick Brandt]

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.

 

[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.

 

[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

 

[Rick Brandt]

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.

 

[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!