Tick boxes from list box

[Vic]

Hello.
Got a Table 'Students' and a table 'Subjects' and others.Student table has
fields subjectID and subjectName
when registering a student I would like for the user to be able to choose
more than one subject if needs.

I tried in the form creating a List Box and choosing the subject table with
both fields but not showing the primary key column
then in the Row Source for the field. I put:

SELECT DISTINCT SubjectName FROM Subjects

but when I went into FormView the box has several lines which you can go up
and down but they are all blank.

Please help
V

 

[Vic]

The other way I thought of doing it is to place a TickBox and call it i.e.
English and in Control Source put a syntax that would choose SubjectName
from Subjects with the value 'English' and then doing that with all the
other subjects
But wasn't exactly getting that right.
As you can tell I'm very new to this so sorry for the ignorance.
Thanks again
V