Edit a table while in form view

[Akilah]

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

 

[Pat Hartman]

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]

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