edit table data via form

[Guest]

HAve a simple form to register attendance. Form is based on query, which is
based on two tables.
Form displays all participants registered for a session. Purpose of form is
to quickly update table, by checking teh attended and/or completed
checkboxes for those enrolled. Attempts to change the status of teh logical
checkbox returns " Record set not updateable" .

I have marked the name and ID fields on the form as DISABLED, but left the
attended and completed checkbox fields enabled. This was done to prevent
someone from inadvertently changing these fields.
The underlying query does allow changes to these two fields, and the changes
ARE recorded in the table.

Any and all suggestions for tracking down this snafu will be greatly
appreciated.

Thanks

 

[Guest]

Update to initial posting, it's been a while. The query actually is based on
four queries to gather all needed info. The query disallows access to these
two fields, so now my question becomes How to make change teh query so that
it allows edits?"

Thanks again.