having some trouble with a recordset being locked

[Jon123]

I'm trying to open or unlock a recordset do do a simple calclation and then relock the record set. Does anyone know if / how this can be done with vba?

 

[Jon123]

ok so my problem is much bigger then I tought. So I have a form that is based on a query from 3 tables. But when I try to update the form I'm getting Recordset not updatable, and I can't figure out how to solve it.

 

[Cronk]

I presume the recordset is based on your query based on the 3 tables.

The issue is that the query is not updatabable because the joins you are using is not enabling the identification of specific records.

Post the SQL for the query.

 

[Jon123]

wow I spent all day working on this issue and just figured it out. I knew it was going to be something stupid I just could not figure it out. On 1 of my 3 tables I did not have a primary key setup. Once I added the PK all was good. Crazy all day and most of the night.

 

[Galaxiom]

So you are storing the results of a calculation based on the data in those tables?
You should not be doing that.

 

[Jon123]

I have to because I need the data put into a table so that I can build a chart from that data. I can't get the charts working if just the form displays the data.

 

[Galaxiom]

No you don't need it in a table. The chart should be based on a query.

 

[Jon123]

so let the query do the calculation and either display it on a chart or on a form.

got it