View Single Post
Old April 26th, 2005, 08:03 AM
rjweers rjweers is offline
Friend of Wrox
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post

This one seems odd. You could check to see if the query of the master form includes a field from one of the tables in the subform or vice versa. If you add a new master, it's going to try to add the associated record in the subform table. Normally, the new record should be created in the subform as soon as someone starts typing.

If the subform is trying to update a field in the master's tables, updates in the subform will have updated the master form's tables while you're in the subform. Going back to the master form and going to a new record will try to update the master's tables again.

Also check to see if you have any code that would update a field on the master from the subform.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group