Maneesh Massey
Member
Hello everyone!
I am basically using Access 2010 to make a small database application, however, I know this is an Excel forum but the VBA code should work for Access as well. I need some help filtering a form with the help of a Combo box. I'm stuck on the part where we can filter the form based on an "ID" selection from the combo box.
I have 3 tables setup for tracking students progress in a small after-school tuition center. The 3 tables are as follows: tblCenterDetails, tblStudent and tblStudentProgress tables.
I have dragged the tblStudentProgress onto the main form and have a Combo box on the form. This Combo box contains a list of CenterID's and selecting a particular ID should populate the form with the CenterID chosen from the Combo box.
The fields in the table are as follows:
tblCenterDetails:CenterID, Address, TotalStudents, AgeGroup
tblStudent: CenterCode, StudentName, Age, Grade
tblStudentProgress: CenterCode, Subject, MarksObtained, MaxMarks, PercentageMarks
I wish to filter records on the tblStudentProgress based on the CenterID selection from the Combo Box.
Can anyone please help me do this?
______________________________________________________________
I am basically using Access 2010 to make a small database application, however, I know this is an Excel forum but the VBA code should work for Access as well. I need some help filtering a form with the help of a Combo box. I'm stuck on the part where we can filter the form based on an "ID" selection from the combo box.
I have 3 tables setup for tracking students progress in a small after-school tuition center. The 3 tables are as follows: tblCenterDetails, tblStudent and tblStudentProgress tables.
I have dragged the tblStudentProgress onto the main form and have a Combo box on the form. This Combo box contains a list of CenterID's and selecting a particular ID should populate the form with the CenterID chosen from the Combo box.
The fields in the table are as follows:
tblCenterDetails:CenterID, Address, TotalStudents, AgeGroup
tblStudent: CenterCode, StudentName, Age, Grade
tblStudentProgress: CenterCode, Subject, MarksObtained, MaxMarks, PercentageMarks
I wish to filter records on the tblStudentProgress based on the CenterID selection from the Combo Box.
Can anyone please help me do this?
______________________________________________________________
Mod edit : thread moved to "appropriate" forum !
