[AccessD] Subform data disappears on addition

After sending the problem in, I finally found the solution on my own; I 
thought I had tried every combination of requery and refresh, but tried it 
again, and found the problem. I'm citing Jim Hewson's comments below, 
because that did indeed turn out to be the problem. When I commented out 
the requerying of the main form, all went well. 

Thank you, everyone, for your help.

BTW, does anyone know of a good explanation of the interactions of 
requerying and refreshing, with regard to forms and subforms? If not, 
would anyone like to provide one? ;-)

Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems


Date: Tue, 20 Mar 2007 13:22:31 -0500
From: "Jim Hewson" <JHewson at karta.com>
Subject: Re: [AccessD] Subform data disappears on addition


Have you tried to requery the subform then refresh the main form?
Don't requery the Assemblies form before requerying the subform.

Jim 
jhewson at karta.com



This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.