Avatar of Karen Schaefer
Karen Schaefer
Flag for United States of America asked on

Refresh combo on 1 form as results of updating another form

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
Microsoft AccessMicrosoft Development

Avatar of undefined
Last Comment
Karen Schaefer

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Kelvin Sparks

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Karen Schaefer

ASKER
thanks for the assist - ended up placing code on close of the forms - works great.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23