Subform qry

[JackT]

I have a form that searches for a reference number in a qry.
Me.RecordSource = "SELECT * FROM qryCheckFiles WHERE " & Me.cmbRef & " = [APU REFERENCE NUMBER]"



I want to populate a sub for to only display rows that match this qry and I am not sure how to do that.

Jack

[ajetrumpet]

WHERE " & Me.cmbRef & " = [APU REFERENCE NUMBER]"

interesting, i've never seen that section reversed. nifty!

I want to populate a sub for to only display rows that match this qry and I am not sure how to do that.

Jack

need more info. a sub based on what? a child of a parent? that info is too vague to figure out jack.

[JackT]

its is a child of a form and the form is bound to the query

jack