two subform link problem

[jefferyzhong]

I have a form which contains two subforms
subform1 link with main form by ORDERID
subform2 link with subform1 by CUSTOMERID

subform1 works well when ORDERID changes
but subform2 only list the data according to the first data of subform1, when I change subform1 sorting from ascending to descending, it can display the different data, but still only the related data from the first data in subform1.

can anyone tell me how to solve this problem!

thanks in advance!

Jeffery

 

[PHV]

Have you tried to Requery subform2 in the Current event procedure of subform1 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jefferyzhong]

thanks for quickly reponse

but could you please explain more detail?

thanks

 

[TheAceMan1]

How are ya jefferyzhong . . . . .

[blue]. . . but subform2 only list the data according to the first data of subform1 . . .[/blue]

You say subForm2 is linked to subForm1 via [blue]CUSTOMERID[/blue]. If subform2 is linked [blue]properly thru Master/Child properties[/blue] to subform1, you shouldn't have this problem.

If you change record on subform1, does subform2 change accordingly?

See Ya! . . . . . .

 

[jefferyzhong]

thanks a lot!

I got it!