Edit a table while in form view

I have a form that has multiple tabs and subforms. On one of the tabs is a
subform with a recordsource that is a query. It shows data from a table in
datasheet mode. In that table I have a field "Selected" which is a Yes/No
field (checkbox). In form view, I want to be able to check the checkbox in
the table in the subform. I don't have that field locked, what other
settings should I check?

Thanks,
Akilah

Can you update fields in the query if you open the query by itself? You
need to determine whether it is the form that is locking the fields or the
query itself.

"Akilah" wrote in message
...

I have a form that has multiple tabs and subforms. On one of the tabs is
a
subform with a recordsource that is a query. It shows data from a table
in
datasheet mode. In that table I have a field "Selected" which is a Yes/No
field (checkbox). In form view, I want to be able to check the checkbox
in
the table in the subform. I don't have that field locked, what other
settings should I check?

Thanks,
Akilah

I checked the query and it was getting Distinct values. When I removed
distinct, the query was updateable. Thanks.

"Pat Hartman" wrote:

Can you update fields in the query if you open the query by itself? You
need to determine whether it is the form that is locking the fields or the
query itself.

"Akilah" wrote in message
...

I have a form that has multiple tabs and subforms. On one of the tabs is
a
subform with a recordsource that is a query. It shows data from a table
in
datasheet mode. In that table I have a field "Selected" which is a Yes/No
field (checkbox). In form view, I want to be able to check the checkbox
in
the table in the subform. I don't have that field locked, what other
settings should I check?

Thanks,
Akilah