Find data in two Forms

[oggsta]

Does anybody know how to use the find command to search throught two tables where there is a main form and a subform with a one to many relation.

I would like to search the main form and all the related records in the subfrom.

If I do a search in the main form it only seacrhes the main feilds.

Any help appreciated.

Thanks

 

[TonyJollans]

Hi oggsta,

Don't think Find can do that. You can search the subform records for a single mainform record but not for the whole lot all at once. It works on an individual recordset (filtered as per the subform if relevant).

You could set up a separate query and search that manually if it is a one-off or, in code you could obviously loop through the lot - I don't know the best way but it can certainly be done.

Enjoy,
Tony