"Unable to update a recordset" 1

[laonei]

Hi,

I am trying to add a new set, but on cliquing 'new', it goes to a record and not blank. Then when I try to modify it, I get an error "impossible to update this recordset".

Thanks for your help,
Laonei

 

[lupins46]

See what happens if you try to update a field in the query that your form is based on. If this produces the same message then you will have to modify your query to produce an updateable recordset. This might mean just adding in PK fields from each table or it might be require more substantial changes.

Just in case you are trying to do this, you cannot produce an updateable recordset if you use a Totals (Group By ) query.

 

[laonei]

Thanks lupins,

Trying to update a normal data, I get the same error.
And strange thing is that I can't change any parameter on 'hotel' table.

Should I post the query here for you to see?

 

[laonei]

Hi Lupins,

Thanks for your help, I did add in PK_ that it's an updateable data and it works. Thanks again for your help.

laonei