subform update based on query in main form

[cedtech23]

I based a subform called frmPatientLookupResults on a Query

and placed it in a main Form called frmPatientLookup

a command button on the Main form called cmdFind

with the following code

Private Sub cmdFind_Click()

DoCmd.OpenForm "frmPatientLookupResults"
Me!frmPatientLookupResults.Form.Requery

End Sub

I know the query works because DoCmd.OpenForm "frmPatientLookupResults"
return the correct results in a separte window.


But the same form as a subform only shows first patient of the table.

Any ideas what went wrong?