How to access a text box on a form within a Navigation form in a report

[rhewitt]

I have a form that supplies a value to a query that is used in a Report. Everything worked fine until I added the form into a Navigation form (switchboard).

When I use the Form within the Navigation form to create the report, I'm prompted for the value that is supplied by the form again.



Do I have to do something different than my original VBA to access the textbox that stores the value used in my query?

[pbaldy]

The syntax to refer to it changes:

Forms Refer to Form and Subform properties and controls

[rhewitt]

Thanks,

I was still having trouble after using the link you provided. Another Access form provided some insight. Rather than referring the sub-form by name, you refer to it by [NavigationSubform]. Here is how mine turned out:

[Forms]![Navigation Form].[Form]![NavigationSubform].[Form]![tboxScientific]

Here is a generalized version for other users:

[Forms]![Navigation Form].[Form]![NavigationSubform].[Form]![formControl]

[pbaldy]

Technically, you refer to the name of the subform control, which the link states. That may or may not be the same as the name of the subform itself.