update recordset

[Andren]

Hi !

I'm still struggeling woth my librarian database.
Have learnt a lot from all discussions in this forum and elsewhere.

Apparently however - I haven't learned enough.

So populating my tabbed pages with combo-boxes related to quearys based on various tables I wanted to put in some data.

But no.

Access refused.

"The Recordset is not updatable" it said - giving no further explanation".

Is there someone out there that can explain why?

/ Anders

 

[Shep]

Several possible reasons...

Your recordset may be based on a query that is not updatable. You might set the Recordset Type property to 'Dynaset (Inconsistent Updates)' to make it updatable. There are certain conditions which will cause a query to not be updatable at all, though...just depends on it's complexity.

Also, in the OpenRecordset statement, you can set the Recordset type. Read help on the OpenRecordset Method.

Shep