VBA CODE OR FUNCTION TO DISPLAY RECORDS FROM COMBO BOX

[mercystone]

Hi everyone. Kindly check the attached database and specifically look at the form. I really need help to find a code or a function to generate records of students doing a particular subject. E g if i select ENG to display students doing ENG, if i select BIO to show students doing BIO only and so on. Thanks in advance.

 

[arnelgp]

see AfterUpdate event of the combobox.
to remove the Filter Clar the combobox.

 

[mercystone]

see AfterUpdate event of the combobox.
to remove the Filter Clar the combobox.

Thanks @arnelgp. Is there a way to hide other subjects and display the filtered subject only? Like if I select ENG then ENG should be shown only and other subjects hidden. Thanks in advance

 

[arnelgp]

see Form1

 

[mercystone]

see Form1

Thank you so much. I appreciate