Why does this recordset become not-updatable

[bginhb]

I have a form with a multi-item subform. The subform is quite complex and its data source is 5 linked tables - it's working just fine but I would like to make changes in the data so it presents more effectively. All data requiring updating are associated with only 1 table.

The data needs some minor adjustment as part of the presentation so I create an additional table extracting the needed pieces from the original form datasource query then create the new sequencing key using a VBA function created especially for this purpose.

Finally I then modify the original form datasource query to include this new table but as soon as I adjust the form to include the new sequencing field Access declares the recordset un-updatable.

I didn't break any rules that I know of. If I remove the table from the datasource SQL it works just fine but I can't get the sequencing I need without shutting off my ability to update the data in the one underlying table that needs updating.

Any help would be appreciated ... Thanks

[RuralGuy]

See if the answer is in this link somewhere: http://allenbrowne.com/ser-61.html

[bginhb]

Thanks for the link Ruralguy. It was a right on the money solution!

[RuralGuy]

Excellent!v Glad we could help.