Connecting Subforms

[AnnPhil]

Subform Hell!!!!

I have no idea what is wrong with my form!! I have a form with a tab control which has a subform on every tab. when i update say subform A i need subform B and C to update. The problem is that subform C updates and subform B does not! they both have the same record source and are related the same way, just wanted to break up the screen and tables. I can not figure out why one would work and the other does not update until i go off the record and then come back. I have tried requery after requery attempts but as i mentioned before the one subform works fine while the other is a nightmare!!!!! Any suggestions out there?

 

[wizcow]

AnnPhil

Try checking your Link Child Fields and Link Master Fields.
Your problem must be with subform B.


HTH
Tom

 

[AnnPhil]

i checked the links they are fine, if this helps anyone figure the mystery out i noticed when i delete a record from subform A and take a look at the other two subforms, one shows the correct updated number of records and the other still show the old total and the fields in the record show the word #deleted# in them.
I know this can happen in a table that is left open when runing a delete query and that when you close and reopen the table it is updated but we are not talking open tables here these are forms. i used the requery but does the refresh work differently? I thought they did the same thing?

 

[wizcow]

AnnPhil

They are kind of the same, but not really.
Requery loads the source file again.
Refresh updates your controls.

Its worth a try.
In your after update event enter...
Me.Refresh

Tom