subform to subform

[John]

I have a mainform with a tab control on it. The tab
control has 5 pages. Each page is a "drill down" of
informtion. The following;

mainform has tab control
tab control has 5 pages
each page has a different subform
each subform is a different table

subform1 = client info (this would be the home office)
subform2 = client locations (around the country
subform3 = claim info (for the associated location)
subform4 = litigation info (for the associated claim)
subform5 = litigation comments (for the associated lit)

I have them linked but what my dillemma is when I go from
the client location tab to the claim info tab, I need to
requery for the proper claim to appear on the prior
location.

Anyone with thoughts on this?
Thanks. John

 

[Marshall Barton]

I have a mainform with a tab control on it. The tab
control has 5 pages. Each page is a "drill down" of
informtion. The following;

mainform has tab control
tab control has 5 pages
each page has a different subform
each subform is a different table

subform1 = client info (this would be the home office)
subform2 = client locations (around the country
subform3 = claim info (for the associated location)
subform4 = litigation info (for the associated claim)
subform5 = litigation comments (for the associated lit)

I have them linked but what my dillemma is when I go from
the client location tab to the claim info tab, I need to
requery for the proper claim to appear on the prior
location.

I presume that the subforms have a record source query with
a criteria that filters the records to the data relevant to
the previous subform. If so, then the requery is required
because the subform does not know (nor should it) that
something has changed. You could use the tab control's
Change event to perform the Requery.

Be careful in this situation, you need to guard against a
use selecting a random tab. E.g. jumping directly from tab
1 to tab 5.