Filter subform using combobox for user to key-in

hanarina

Registered User.
Local time
Today, 03:10
Joined
Oct 29, 2012
Messages
14
Hi...

I have this problem that I'm not sure how to do it..
I'm trying to filter a subform using a combobox so that user can key-in data. The subform can only show certain subject(the subject already in there, user dosent have to fill on the subject), and the user only have to enter the point.. The problems is, I have many students with the same subject with different programme also the same student woth different subject..

Eg:
Students A - computer science
Math
Computer
Physic

Student B - business
Math
Economic
Psychology

Student C - computer architecture
Math
Computer
Multimedia

I've been trying to figure this out for a week now.
Thank you..
 
Is your data is normalized properly? There should be separate table for subjects and all subjects should have their IDs which can be referred in Students records for grouping them together for each subject.
 
As Khalid said -- Normalization is your issue.

Thank you for the reply, I already create a separate table for subject and connect both student detail table and subject table. Then I got stuck on what to do next .. mayb my explanation is not clear enough. What I'm trying to do is a list of subjects in the subform is automatically shown once the user choose from the combobox. all the user have to do is enter the point for all the subject listed in the subform.

Sorry I'm bad at explaining stuff, so I attach a picture and my database

P/S: Also sorry if my english is weird~
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    64.2 KB · Views: 109
  • Database11.accdb
    Database11.accdb
    1.4 MB · Views: 122
I recommend you review Normalization. Review each of your relationships. See if all current relationships make sense.
 

Users who are viewing this thread

Back
Top Bottom