Subform will not requery

S

Steven

I posted this earlier but with no sucess and I have uncovered a new fact that
I hope will show what is going on.

I have a Master Form with a Subform. The Subform Object is linked with Link
Child Fields: Field1 ; Field2 and Link Master Fields: Field1 ; Field2. I
have a procedure that imports an excel file into 2 tables. One table is the
Record Source for the Master Form and the other table is the record source
for the Subform. After the import I requery with Me.Requery and
Me.SubformObjectName.Requery but the subform does not show the records it
should. If I close the Master Form and then reopen it, then the subform
shows the records properly.

I then decided to do a test by taking out all the fields on the Main Form
and just left the subform object. I then ran the import and then did the
Me.SubformObjectName.Requery and the Subform requeried properly. Is there
something going on with the Link Child Fields ; Link Master Fields after the
records are added from the import. I dont get this because when I exit the
form and then reenter it everything is ok.

I appreciate any help on this.

Thank you.

Steven



Thank you for your help.
 
Top