DoCmd.OpenForm based on a query with a parameter

[RobLoughrey]

I want to make a button to open a particular set of records in a navigation subform. The Macro wasnt working for me and I think its because my where condition is too long. So I am trying VBA instead using DoCmd.OpenForm The VBA I am using (unsuccessfully) is

DoCmd.OpenForm frmRCRViewClaimEdits, acNormal, qADTeamSummaryBtn, "Team" & [Forms]![MainMenu]![btnManagersMenu].[Form]![NavigationSubform].[Form].[cmbTeam]

I'm getting an error message saying I need a valid form argument. I'm a bit of a scrub at VBA so I'm fairly sure I've just done something dumb and I'm hoping one of you can set me straight.

[June7]

Presume code is in button Click event on MainMenu.

Not really clear to me what the form structure is.

btnManagersMenu is a subform?

Then you have a Navigation form on that subform?

I've never used Navigation form. Review https://www.accessforums.net/showthread.php?t=32053

[aytee111]

The form name needs to be surrounded by quotes.

[June7]

Good catch aytee.

And I expect the FilterName argument parameter needs to be within quote marks as well. I have never used the FilterName argument

[RobLoughrey]

The Form is contained in a couple of Navigation Subforms. My MainMenu is a Navigation form, followed by two more. I'm pretty sure I have the pathing right because when I run the query from the navigation pane it gives me the exact records I'm looking for. If I run the query from a Macro Button I get a parameter window asking for the Team value. I made the quotation mark suggestion for the form name and that did get me past the error I mentioned in the OP. I still keep getting asked for the Team parameter. I've tried having all of the criteria for the query inside the query and just running

DoCmd.OpenForm "frmRCRViewClaimEdits", acNormal, qADTeamSummaryBtn

but that returns all records - apparently ignoring all of the criteria set in the query.

[June7]

Try not using the FilterName argument. As I said, I have NEVER used it.