Subform driven by query, not allowing edits

[nathan_savidge]

Hi, i have a subform which is driven by a saved query. This query is joined
to 2 other tables (simply take the users_id and matches to their name, and
the same for Provider ID matching to provider name) This part is fine.

However, i need to be able to edit the results that this query is producing,
but i am not allowed to make edits. I have no record locks and allow edits
is YES.

Is there a way of allowing edits in this, or getting around it.?

Thanks in advance.

 

[bhicks11 via AccessMonster.com]

Your query is probably not updateable. Open the query and see if you can
make any changes directly in it. If you can, it is a form setting/issue but
I believe it is your query.

To read about how to make your query editable and why some are non-editable
queries see this:

http://office.microsoft.com/en-us/access/HA100978761033.aspx

Bonnie
http://www.dataplus-svc.com