Navigation Form w/ Requery on Subform 2

[Robecca]

I recently took an intermediate Access class and we were introduced to the Navigation form.

I have a form [RecapSheet] that I put on a tab control [TabScoreEntry] in another form [ScoreEntry]. The tab control [TabScoreEntry] has a few tabs, one is Recaps which has an option group called TeamList.

I have a query called Recap. I turned it into a parameter query based on the option group TeamList. So when a button in the option group TeamList is clicked, I am running the After update Event to requery.

My current code on the After Update Event is:
[Forms]![ScoreEntry]![RecapSheet].Requery

My current criteria in my query is:
[Forms].[ScoreEntry].[TeamList]

And it works fine until I put the form [ScoreEntry] on the navigation form.

I'm needing help with the correct syntax. I'm a beginner at code and I thought I would just be adding the level of the navigation form in front of the form [ScoreEntry]. It does not work

I have spent hours last night googling but still have not figured this out.

Thanks! Robecca

 

[Robecca]

Re: Navigation Form w/ Requery on Subform 2 - SOLVED

In case someone else is looking ... this was solved with:

[Forms]![NavigationForm]![NavigationSubForm].Form.[Subform].Requery

The Subform is the "subform 2" name, the form I dropped on the navigation form is not mentioned.

Robecca