Search Data in a SubForm

U

UTOPIAN

Hello, very good day!

I have a Main Form with a SubForm. In the Main Form I have a button SearchName + a Text Box in which I introduce for example the data to look for in subform......

How I am due to refer to that Subform and a control of the same one?

Thanks to all!
 
A

Allen Browne

If you search the subform, you are only searching the records that are
currently loaded, i.e. the ones that match the record currently in the main
form.

If you want to search all the related records, and limit the main form to
those records that have a match in the subform, see:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hello, very good day!

I have a Main Form with a SubForm. In the Main Form I have a button
SearchName + a Text Box in which I introduce for example the data to look
for in subform......

How I am due to refer to that Subform and a control of the same one?

Thanks to all!
 
G

Gisela Arce

Prueba
"UTOPIAN" <[email protected]> escribió en el mensaje Hello, very good day!

I have a Main Form with a SubForm. In the Main Form I have a button SearchName + a Text Box in which I introduce for example the data to look for in subform......

How I am due to refer to that Subform and a control of the same one?

Thanks to all!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top