Open a form based on a link in Subreport

[RapidRepairArnold]

So I have built a Navigation form that shows all our products through a Subreport. One of the things I would like to have is for the end user to be able to click a link and have a popup show with the detailed information on that record. I have everything set and all is working well except that the link will not work when I go through the navigation form (I get the "Enter Paramaeter Value" prompt)....but it works when I am in the report itself (not as a subreport). I am pretty sure it is my code and the where condition (using Macro's). it is:

Where Condition=[Unique_ID]=[Reports].[Pricelist_Item_View].[Control_UniqueID]

I am pretty sure I am just not addressing the path correctly. Any help? Also, the main form I am using is named [Pricelist], while the subreport is in NavigationSubform

[June7]

Does this help https://www.accessforums.net/forms/n...ers-28983.html

[NTC]

I am not clearly able to interpret your post; are you indeed putting sub 'reports' inset into 'forms' ? I have never mixed two different objects like that together. Although I am not saying that is the cause of the error.

Definitely your Where statement cannot include two = = and so you'll want to revisit the syntax on that; Specifically look at form/report opening argument Where syntax

[June7]

NTC, OP is showing macro, not VBA, code, hence the two = signs.

[RapidRepairArnold]

June7,

Thanks for the link, but the problem with that resolution is that it is filtering and not opening one specific record. I tried running that thru my head and it doesn't seem compatible with my end goal...

[June7]

Point is, the issue of correct syntax to reference navigation subforms was the same. That poster just happened to find a solution for filtering with macro that was compatible with the reference syntax. Did you visit the link referenced in post 2 of that thread?

I don't use navigation form and previous attempts to help posters which this syntax issue have been frustrating. I have yet to figure it out and can't find any decent guidelines.

[RapidRepairArnold]

June7,

Just reporting back, and I got it figured out. I ended up setting a TempVar for it, and then doing the filter by that temporary filter. Thank you for pointing me in the right direction.