Access/SQL- Parent Form with Subform, when user clicks in subform, sometimes Parent Form loses it's place!

[BrianDP]

I think that pretty much sums it up!

I have a couple of forms in this contact management/Sales tracking database.

 

In one instance the user is in the customer form, which has an attached subform for notes.  When the user clicks into the notes subform, the customer form seems to lose it's place.  It will jump to a completely unrelated customer.  No rhyme or reason why.  I reminds me of the old record jumping because of the scroll wheel being hit by accident but the user assures me that isn't the case.  Anyone seen this happening?  It is similar to another problem we've had in the same database, with the same linked back end.

 

In the second instance the user is in the Quotes file.  He is entering the attached quote line items for the quote, (sizes of packages actually, but the same as any other subform.  In this case, when he clicked into the subform, the parent form went to nowhere!  The parent form displays #deleted in all the fields, and comes up with a foreign key message about how it can't enter the child since the parent doesn't exist.  Even though these two errors aren't exactly the same it just feels like the same type of problem.  Like Access and SQL aren't communicating correctly or something. 

 

Even though these aren't happening very often, The database has been up for 2 years now, and the problem has only gotten so noticable that we've been tracking it for about 4 months.  In the last 4 months, this Jumping thing has happened a total of 6 times, 4 times in the customer screen, and the other two in other screens.  Of course since they can't readily reproduce the error in front of me, it's hard to get a real sense of how it propogates itself.  Does anyone have any idea about how to trap this, or maybe you've seen something similar and it's as simple as a switch - "AllowSQLCommunication=Yes?"

 

No.  I didn't think it would be that easy.

 

-BrianDP