VBA CODE OR FUNCTION TO DISPLAY RECORDS FROM COMBO BOX (1 Viewer)

mercystone

Member
Local time
Today, 06:34
Joined
Sep 20, 2021
Messages
108
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.
 

Attachments

  • GRADEMARKS.zip
    54.9 KB · Views: 283

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 11:34
Joined
May 7, 2009
Messages
16,812
see AfterUpdate event of the combobox.
to remove the Filter Clar the combobox.
 

Attachments

  • GRADEMARKS.zip
    59.3 KB · Views: 108

mercystone

Member
Local time
Today, 06:34
Joined
Sep 20, 2021
Messages
108
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

..forever waiting... waiting for jellybean!
Local time
Today, 11:34
Joined
May 7, 2009
Messages
16,812
see Form1
 

Attachments

  • GRADEMARKS.zip
    96.5 KB · Views: 310

Users who are viewing this thread

Top Bottom