Troubleshooting me.requery for multiple subforms.

[selvsagt]

I have a mainform (frmQuizScore_begge) with 2 subforms for answered quizzes, and not answered quizzes.

I the mainform I use an unbound combobox named txtCriteria with rowsource:
SELECT QryQuiz_testliste.testID, QryQuiz_testliste.test FROM QryQuiz_testliste;

Testliste shows the different Quizzes.

The combox should show the testID and testname, but only shows the testID (thats ok for now).
In the after update I have Me.Requery.

The query sources for the subforms has the following criteria for showing testID:
Like [Forms]![frmQuizScore_begge].[txtCriteria]

So far I have data on three different testID's, 6, 7 and 8)

The query seems to work fine, the right values appear when I change the value in the combobox in the form, but the subforms only shows values when I pick testID number 8 in the combobox...hmm (?).

Why does not testID nr 6 and 7 show in the form when I pick them?
I have no clue on this one.

 

[Dennisk]

me.requery only operates on the form it is executed from
So you need to requery each subform as well

 

[selvsagt]

How, or were do I do that?
Now it's written in the after update event of the combobox.

(and why does testID 8 work, but not the others???)