Macro works on form, but not when form is on a Nav Form

[pschonen]

I have a Web Database i have built. It is homed on Sharepoint access services. I dont think any of that is the problem however.


I have a button on a form that brings up a multirecord form based on a table, filtered by a field in the original form. The button runs the "openform" macro.
The button works WONDERFULLY when i open JUST the form on which the button is located. However, this form is located on a navigation form (Actually a nav form ON a higher level nav form). When i open the form through the nav forms it no longer works, telling me there is an error in the expression.

It gives the same error whether i load it locally in Access or via the website.

Any Ideas how i can resolve this?

[June7]

Review https://www.accessforums.net/forms/a...tab-41032.html

[pschonen]

OK... so if i understand this correctly, I think i just need info on the Heirarchy of nav forms and how to fully address a control on a form that is on a nav form. I have added a screen shot below. As you can see i have 2 layers of Navigation, vertical tabs then horizontal tabs, before i get to an actual form built from a query.
The button brings up a form in a separate window (dialog box). I have added the embedded macro as well.
If anyone can direct me to the proper heirarchy for forms on nav forms, I would be appreciative.

[June7]

Did you fully review the referenced link and the additional links? Do you understand why the suggestion was to use TempVars? Trying to reference through multiple layers of navigation form sounds really difficult. I've never built web db and have no use for navigation form.

As I understand it, the referencing is like:

Forms!mainformname.NavigationForm.Form.controlname

Bing: Access navigation form reference subform

[pschonen]

Well when at first it wasn't working even straight on the form directly, I tried setting a tempvar siteref=[Site_ID] then in the query underlying the form i was calling, i set the parameter siteref and used siteref in the QUERY as a criteria.

Problem is, any time i specify a parameter that is not specifically a form control or something similar, it asks for the input instead of it being passed from the calling object.

[June7]

I've never used TempVars but possibly they can't be referenced in query.