Access 2007 bound checkbox won't check, unbound will...

[natwonder]

I have a checkbox that when bound to a field in a query which relates to a yes/no field in a table will not check/update. When I make the checkbox unbound it checks.

I am sure I am missing something simple, but am going crazy trying to figure this out. Thank you for your help!

 

[dhookom]

Can you update the value directly in the query? Is the form set to allow updates?

Duane
Hook'D on Access
MS Access MVP

 

[natwonder]

Of course I figured it out right after I made the post..

The query wasn't updateable due to the primary key of one of the lookups not being set up correctly.

Thank you!