Solved DYNAMIC SEARCH FROM A FORM TO DISPLAY RECORDS IN SUBFORMS (1 Viewer)

[Mercy Mercy]

Hello everyone. I am humbly requesting on how to create dynamic search from a form to populate records in subforms. The records should be shown as you type or when you click search.
I have the following subforms from different tables.

1. Tblstudents
2. Tblyears
3. Tblgrades
4. Tblterms
5. Tblexaminationstypes

From tblstudents let's pick student A as you search it should display the records of Student A.

Thanks in advance. If there is a sample, I will be very grateful. Thanks in advance.

 

[CJ_London]

Assuming you are using a combo to pick a student just use the subform control link child and link master properties

 

[Gasman]

Alternatively google allen browne search form