William Hindman
wdhindman at bellsouth.net
Tue Apr 15 05:45:27 CDT 2003
...afaik you can't normally update bound records from snapshot recordsets ...HTH :) William Hindman "All it takes for evil to prevail is for good men to do nothing." Edmund Burke ----- Original Message ----- From: "Dan Waters" <dwaters at usinternet.com> To: "'AccessD at databaseadvisors. Com'" <AccessD at databaseadvisors.com> Sent: Monday, April 14, 2003 5:26 PM Subject: [AccessD] Error: -2147352567 ?? > The error description is 'Update or CancelUpdate without AddNew or > Edit.' > > I've checked for this problem and can't find it. This occurs repeatably > (at least once a day) in the after update event of a several different > comboboxes on a subform (so most of the time it doesn't happen). The > subform is bound to a table that is on the many side of a one to many > relationship with the table that the main form is bound to. This is in > an AXP split database, FE and BE are both mdb's. The comboboxes use > snapshot queries as their row source. > > Has anyone seen a negative error number like this? I couldn't find it > on the MSKB. > > Dan Waters > > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >