Refresh combo on 1 form as results of updating another form

Karen Schaefer
Karen Schaefer used Ask the Experts™
on
I am drawing a blank here - where is the best place to place the Requery/Refresh - when I update the list of a combo on 1 form I want it to be displayed in the combo on another.

FormA.SubForm1.Combo1 - list of Assignment Types to be assigned to a specific Organization.

FormB.Subform2.combo2 - List of Assignment Types - Need to add to the list that will be displayed on FormA.SubForm1.Combo1

I have tried the refresh on the load of the Subform1, on the Load of FormA,
OnClick of the Combo1, on BEforeUpdate - all without success.

Please help,
K
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
On the form after update of form 2 create an event that has

Forms!FormB!Sunform2.Forms!Combo2.Requery


Kelvin
Karen SchaeferBI ANALYST

Author

Commented:
thanks for the assist - ended up placing code on close of the forms - works great.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial