We help IT Professionals succeed at work.
Get Started

Referencing a Control on a sub Form on a Navigation Form

959 Views
Last Modified: 2016-02-11
I have a form frmVenAttendence that I added into a navigation form frmNavigation. the frmVenAttendence has a text box control  named businessname which is used on a report to display the contents of that control on the report. The report control  Source is =[Forms]![frm_VenAttendance]![businessname] which works fine outside the the navigation form. I know that when you put the form into a navigation form it actually becomes a subform of the navigation form and I need to reference both, but I am having a hard time getting the syntax correct. I have tried
 =[Forms]![frmNavigation]![frm_VenAttendance].[form].[businessname]
=[Forms]![frm_VenAttendance]![frmNavigation].[form].[businessname]
neither work and am asked to enter the parameter value for that control.
Comment
Watch Question
IT director
Commented:
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE