J
jean
Hi
I have a Form "Terms" containing 2 subforms "Terms1" and "Terms2"
Main form "Terms" as no source
Subform "Terms1" (continuous form) is based on a table
"CommercialTerms" and contains 4 fields. One of the field is named
"Profit"
Subform "Terms2" (continuous form) is based on a query and this query
is based on the table "CommercialTerms"
When I change "Profit" on one of the record of Subforms "Terms1" I
would like to see results on Subform "Terms2"
The only way right now I can manage is with a command button on the
main form that would requery "Terms2"
I have try many things with the event "After Update" of the "Profit"
field but each time I got an error message like if routine don't want
to leave "Terms1" to requery "Terms2" Cannot find Terms2 ....
I have try to call a subroutine "Call RefreshForm" where
"RefreshForm" = DoCmd.requery "Terms2" without success.
I am sure it is easy, but I cannot find it
Thanks for helping
I have a Form "Terms" containing 2 subforms "Terms1" and "Terms2"
Main form "Terms" as no source
Subform "Terms1" (continuous form) is based on a table
"CommercialTerms" and contains 4 fields. One of the field is named
"Profit"
Subform "Terms2" (continuous form) is based on a query and this query
is based on the table "CommercialTerms"
When I change "Profit" on one of the record of Subforms "Terms1" I
would like to see results on Subform "Terms2"
The only way right now I can manage is with a command button on the
main form that would requery "Terms2"
I have try many things with the event "After Update" of the "Profit"
field but each time I got an error message like if routine don't want
to leave "Terms1" to requery "Terms2" Cannot find Terms2 ....
I have try to call a subroutine "Call RefreshForm" where
"RefreshForm" = DoCmd.requery "Terms2" without success.
I am sure it is easy, but I cannot find it
Thanks for helping