troubleshooting Question

Code for Requery for a Combo Box Located in a Sub Subform in a Tab Control

Avatar of rsb1222
rsb1222 asked on
Microsoft Access
2 Comments1 Solution1200 ViewsLast Modified:
Novice here.  I need code for an After Update event for a Combo Box on a main form.

I want to requery a combo box that is located in a subform of a subform which is located in a tab of a tab control.

Form:  frmOpportunities
Tab Control:  TabCtlOpps
Tab: General
Subform: sbfrmOppProjGeneral
Sub Subform: sbfrmOppProjContact
Control:  cboContactPerson

Here is what I've tried:

Forms!frmOpportunities.TabCtlOpps.General.sbfrmOppProjGeneralInfo.sbfrmOppProjContacts.Form!Controls.cboContactPerson.Requery

(all on one line)

Thanks!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros