This Recordset is not Updatable

[bcooler]

Hello-

I'm having a problem with a form. The form has comboboxes, textboxes, and 2 subforms.

If I choose "Dynaset (Inconsistent)", I can enter data, but the form doesn't seem to remember previously entered records and the subforms do not populate.

If I choose "Dynaset", All my forms populate, including the subforms, but I get the "This Recordset is not Updatable" in the bottom left of the screen.

I've Googled the problem, which suggests the problem comes up if I am based on a multiple table query and don't enter a primary key. I looked and made sure I had a primary key in all the associated queries (not sure which one [record source, control source query, etc] needs a primary key?).

Here's the questions:

1.) What item needs a primary key? I assume the underlying control source, which is a query?

2.) What are the pro's and con's with Dynaset vs. Dynaset(Inconsistent)? How is the "Inconsistent" part going to eventually bite me on the rear?

3) How do I solve this issue? Should I use Dynaset (Inconsistent) and then requery the form on the AfterUpdate Event?

Thanks in advance!!

 

[TheAceMan1]

How are ya bcooler . . .

To tell if the [blue]Recordset[/blue] of a [blue]form or query[/blue] is [blue]updateable[/blue] have a look at the AddNew button, if it has that disabled look then the recordset is uneditable!

Note: for the proper indication in forms the [blue]Allow Additions[/blue] property has to be set to [purple]Yes[/purple]. If set to [purple]No[/purple] the visual effect is the same as [blue]disabled![/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bcooler]

Thanks for the input. "Allow Additions" property is set to "Yes". I can generate a Add New record.

I'm still having problems getting around the Records not updatable. What do I need to do to not have this error show up?

 

[bcooler]

OK, I set everything back to Dynaset, simplified my query to include all primary keys (missed one), etc. I can enter data without the error, but still have one problem.

The subform will not update automatically. I have to change records and come back, close and come back etc. I have tried me.requery and me.subformname.requery, but no success.

SOS! I'm circling the bowl!

 

[bcooler]

OK. Got it to work. I remembered something I was told on this site from a question a while back. Sometimes it's better to make the master of a master/child cross reference via a textbox. The control source of the textbox is the original master that Access sets up. Then, when the form updates, the textbox and the subform link gets updated also. Don't ask me why or how, but it work great. I just have to hide the textbox if I don't need it visible to the user.