Update fields in one to many query

[davea300]

I have a one-to-many query with two tables. I'm using the query as a record source for a subform.

The subform displays the correct data I'm after however I can't update any fields on the it due to the underlying query having a one to many relationship. I understand that and thats fine.

Problem is I need users to be able to update one field on this subform as required. Is there a way to allow this while keeping the underlying query the same?

 

[Roly Reefer]

You can't update the query itself - you need to create another subform and link this to the table that the field is in and put it on the other subform.

HTH,

Roly