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.

 

[mike60smart]

This is how I would do it

 

[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

 

[arnelgp]

i suggest you make a mockup of your form.
how you want it to appear.

 

[mike60smart]

I agree with arnelgp the Op needs to give us an example of how he want his Form to look.