Refresh a value pulled from another form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a read-only control (InsuranceVale) on a tabbed sub-form that
references and displays the value that has been entered in a similarly named
control on my Main form. (Thanks to Arvin Meyer for helping with this).
If I enter a value on the Main form and then move to the sub-form, the value
is not displayed. Clicking on Save doesn't seem to help. It seems as though I
have to exit back to the switchboard for the change in value to become
effective in the sub-form.
I guess I need something in the On Change or On Exit property of the control
on Main (??) but I would appreciate advice on this, please!
Many thanks
CW
 
As you move from the Main Form to the SubForm the AfterUpdate event of the
main form is triggered.

Use that event (AfterUpdate of the main form) to refresh the values in the
combo in the sub form

Me.[SubFormControlName].Form![ComboName].Requery
 
Back
Top