Access 2013 VBA problem refreshing a list box

I am developing an Access application.  I read data from a sql server table and populate an access table which is used as the data source for a combo box.  After the application runs some of the retrieval process, the new data is in the Access table, but is not reflected in the combo box which just has values like #DELETED.  I'm pretty sure the combo box just needs to be re-queried with a statement like this:

cboCompanyName.Requery

The combo box is not on the same form as the one that needs to run this query and I get an error that says object error 424  Object needed.  I think I need to use a fully qualified reference to the combo box.  How?  I don't see any name property for the form, I  don't know what the form is named.  It does have a label (which has a blank in it), and I have tried something like this:

[Company Selection].cboCompanyName.Requery

and

[Company Selection]!cboCompanyName.Requery

Which do not work.  Do forms have a name property?  How can I find it (if it does)?  How to I reference this combo box from a form that is not it's container?

Thanks,

Cipriano
cipriano555Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
try

Forms![NameOfForm].cboCompanyName.Requery

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PatHartmanCommented:
You might need a bang instead of a dot after the form name.

Forms![NameOfForm]!cboCompanyName.Requery

NameOfForm is the object name.  Keep in mind that the form you are referencing MUST be open or you will get a reference error.  You can trap the error and ignore it if that is OK for your situation since when the form opens, the query will automatically run.
cipriano555Author Commented:
It worked!  Thanks
PatHartmanCommented:
Glad it worked.  Please choose the answer that helped you and close the question.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.