Refresh a value pulled from another form

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top