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