Recordset not updateable

[jjake]

I'm having a problem with a form with multiple subforms.

I have a main navigation form (frmHome) which has a tabbed control (tabCtl1). within the tabbed control is another form. (frmProjMan) this is a continuous form to display all projects. Control source is tblProjMan

When a record is selected it opens a popup form (frmProjDetails) to filter the selected record which has another tabbed control (tabctl2). within this control is yet another form (frmProjDetails). record source (tblProjMan) This details form is where i'm supposed to enter/edit information this particular record but i keep getting a recordset not updateable error. If i open the form directly from the object menu i can edit it no problem. Also if i add an unbound textbox i can type in it.

Help!!! :banghead:

 

[NauticalGent]

Your forms Record Source, probably a Query, is read only. Lots of reasons for this, but easily fixed.

Give this a read:
http://allenbrowne.com/ser-61.html

Additionally, at the bottom of this thread, there are a few Similat Threads on this forum that can help.

Best of luck!

 

[jjake]

All forms are directly from the table. No query is used. I have also double check all form properties to ensure Allow Deletions, Additions, Edits and filters are "Yes". Record locks are also "No". All fields are also enabled and not locked.

 

[jjake]

I do use a where clause on the open form statement in VBA if that makes a difference to filter the ID to match the ID.

 

[NauticalGent]

I see. Then I would guess it’s your table relationships that is tripping you up.

 

[mohamedmatter]

Your forms Record Source, probably a Query, is read only. Lots of reasons for this, but easily fixed.

Give this a read:
http://allenbrowne.com/ser-61.html

Additionally, at the bottom of this thread, there are a few Similat Threads on this forum that can help.

Best of luck!

i tired but error display i wait you to hlp me

 

[JHB]

I'm having a problem with a form with multiple subforms.

Post your database with some sample data.

 

[jjake]

See the attached link the download the file. Please note that the table and form names are different then i previously stated. I simplified them for the forum post.

http://s000.tinyupload.com/index.php?file_id=75662675278900075975

the project management section is what you should be looking at.

 

[JHB]

You've locked all records in form "frmProjectManagement" which is based on query "QryProjectDetailForm", which get the data from table "tblProjectCoding", the same table as form "frmProjectDetails" and form "frmProjectDetailsSummary" are based on, therefore you get a "recordset not updateable".

Set the Records Locks to "No Locks".

Next time you post a database, do a "Compact & Repair" and zip it, then you can post it directly here at the site.

 

[jjake]

Whoops. Just when i thought i triple checked everything. I guess it helps to have a fresh set of eyes look at it. Thanks for your help.

 

[JHB]

Yes, it's hard to see the mistakes you make, others are much better to that!
Good luck with your project!