COMBO BOX FOR SUBJECTS AND ADD MARKS MANUALLY

[I am alive]

Hi everyone,
Please kindly someone to assist me. I am trying to make a student attendance marks database. I want to populate a combo box where you select from a drop-down a subject and add marks:-
Subject A
BIOLOGY
PHYSICS
CHEMISTRY

SUBJECT B
BIOLOGY
PHYSICS
CHEMISTRY

SUBJECT C
BIOLOGY
PHYSICS
CHEMISTRY
A student can do at least 2 subjects. Any help will be highly appreciated. Thanks.

 

[June7]

What do you mean by 'populate a combo box where you select from a drop-down a subject and add marks'.

A combobox to list subjects should be simple. Enter mark in appropriate field.

Exactly what issue have you encountered?

Why are students limited to 2 subjects?

 

[I am alive]

I need a drop-down to select a subject let's say Biology and add marks. A student may do biology and physics only and another student may do physics, biology and chemistry.

 

[June7]

So why would one student do only biology and physics and another gets to have 3 subjects? Are students really limited?

So again, a dropdown to select a subject should be simple. Do you have a table of subjects? Use that as the source for combobox. Then simply enter a mark into another field.

You say you are 'trying' - so what have you done and what is the exact issue you encounter? If you want to provide db for analysis, follow instructions at bottom of my post.

 

[Gasman]

I would have a combo for the Exam, another for the Subject Class and a textbox for the mark.

 

[arnelgp]

here is a demo.
enter all subjects to subjects form.
enter students and subject to student form.
enter attendance to attendance form.
attendance is recorded in attendance table.

 

[I am alive]

I need a drop-down to select a subject let's say Biology and add marks. A student may do biology and physics only and another student may do physics, biology and chemistry. If a stu

here is a demo.
enter all subjects to subjects form.
enter students and subject to student form.
enter attendance to attendance form.
attendance

here is a demo.
enter all subjects to subjects form.
enter students and subject to student form.
enter attendance to attendance form.
attendance is recorded in attendance table.

This is the best. However, there is option of entering the marks scored by a student example
Student A scored
Physics-80
Biology-70
Student B scored
Physics-90
Biology-70
Chemistry-60.
Student A can do only two subjects physics and biology while Student B can do all the three subjects physics, Biology and chemistry.
Thanks for going extra mile. I really appreciate. Kindly assist me. God bless you.

 

[I am alive]

I would have a combo for the Exam, another for the Subject Class and a textbox for the mark.

Thanks. Demo please. I will really appreciate

I would have a combo for the Exam, another for the Subject Class and a textbox for the mark.

 

[Gasman]

I do not do Demos, that is arnel's territory, and you were not happy with what he supplied you.

See if you can work something out from here
https://www.google.com/search?q=acc...69i57j69i64.9969j0j9&sourceid=chrome&ie=UTF-8

 

[arnelgp]

I thought differently between attendance marks and grade marks.

 

[arnelgp]

here again.
grade marks are saved to GradeMark table.
i used 4 grading periods.
i used the ID of StudentSubjects table as PK (StudentSubjectsID) of the GradeMark table.

 

[Pat Hartman]

arnel showed you how to do the dropdown to filter the subform but he used a non-normalized table so his sample gets a thumbs down. Each grade belongs in a separate row whether you are recording grades individually or by grading period.

 

[mike60smart]

This is how I would do it

 

[Pat Hartman]

@mike60smart's solution is much better. However, when entering grades, usually you would do it by subject rather than by person so the mainform should be the subject and the subform should be the student, the date and the grade and possibly a testID so that it is easy to obtain all the scores for a single test.

 

[arnelgp]

used a non-normalized table so his sample gets a thumbs down.

you should see what is going on first before you comment.. " >>> DELETED BY UG <<< "

I am sure that the word you used does not mean what Google Translate told me it means. I'm sure there has been some sort of mistranslation. However to be on the safe side, I have deleted it. If I ever see any similar "mistranslations" I will take further action. - UG.

the subfom is but a placeholder, it does not get saved, the Grades
are saved to a Normalized table "GradeMarks" table.

 

[arnelgp]

This is how I would do it

read post #7, the op want a dropbox of subjects.
so the form is "grouped" by subject, not by each student which is very easy.

 

[The_Doc_Man]

Arnel, I SINCERELY hope that you meant to use "puta" as Latin Imperative case for "Think" ...

 

[I am alive]

This is how I would do it

Perfect. Exactly what I needed. Thanks for going the extra mile. How do you develop reports based on this? You have really helped me. God bless you

 

[I am alive]

This forum has really helped me. I am new to ms access. Thanks guys.

 

[I am alive]

@arnelgp and @mike60smart God will bless you so much. The two demos are very effective. Thanks so much