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
Ofer Cohen - 16 Jul 2007 07:06 GMT
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

Signature
Good Luck
BS"D
> 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
[quoted text clipped - 7 lines]
> Many thanks
> CW