sub forms ...

[jacquienta]

Hi i have set up nested subforms and i need to search through the second subform to find a field that relates to a field in the upper/main form.



ie. name in main form. siblings in subform. I want the search to only show the siblings relating to that one person and at the moment it is showing me all the siblings in the list.

how do i link the search to show only the siblings relating to name?

I'm using a combo box for the search..

any pointers would be much appreciated, thanks.

[ranman256]

Use a query that reads the combo box and uses the key in the master form.
docmd.openQuery "qsMyQuery"

[orange]

What are the link fields between forms?
Show us some code and a jpg of your relationships window.