help with Combo boxes, I think???

[edith]

I am a relative newcomer to Access. With the help of a few experts on this
forum, I successfully managed to build a database a year ago for a project
and need to do another one but can't remember a lot of what I learnt last
year...! I would really appreciate some more help.

I have a table with class details. There are several different fields (eg
day, time, venue, teacher, subject, level).

I have another table and form with the student details. I now need to go to
each student record and enter the classes they attend (i have the classes as
a subform on the student details form).

From the class subform on the student record, I need to be able to go to
ClassID and get a drop down box that will show me the full details for each
class
eg ClassID 1 = Monday, 10am, Maths, Room 3, Mrs Brown, level 2
At the moment, I go to the ClassID and just get a drop down box with a list
of numbers which are meaningless.

I know I manged this last year but can't for the life of me remember
how....!!! Sadly I don't have much time to get this database built, and I am
sure it is an easy solution...



Thanks
Edith

 

[Jeff Boyce]

Edith

If you built one last year, have you looked at it to see how you handled it
then?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[edith]

Hi Jeff,

When I did last year's it was on someone else's pc which I no longer have
access to (forgive the pun!), and stupidly I didn't keep a copy for my own
learning!

 

[Jeff Boyce]

Edith

If I understand correctly, you have a one-to-many relationship between
classes and (enrolled) students.

One way to handle this is to use a main form based on the class, and a
subform based on the enrolled students.

This implies three tables ...

tblClass

tblStudent

trelEnrollment

Is this how your data is structured?

Regards

Jeff Boyce
Microsoft Office/Access MVP