Find Record in a SubForm

[Jul]

Hello,

I hope can help me.

I have a main form with txtbox and a command button, with them I want to
make a search of registries in a control that is in a subform of the main
form.

how I solve it?

Thanks!!

 

[Allen Browne]

Usually, a subform shows only the entries that relate to the record in the
subform. If you search the subform, therefore, you are only searching the
records that are currently loaded, and so it does not find most of the
entries.

If that's the problem, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html
The article explains how to use and INNER JOIN statement in the RecordSource
of the main form, so it contains only those records that have a match in the
subform.