I have a mainform with a Link master field tied to a subform
I am looking for corresponding records but searching through the fields of the subform hoping however that won't work (as I am guessing I am on the mainform record) - is there a way to search records through the subform?
each mainform record brings up the correct record on next but searching would be nice as details like date are kept in the subform table.