Enrol entry

[jagguy]

I have 3 tables in Access 2007.

I have a basic question.

I have a student, subject and an enrol form where the Enrol table is related to the other forms.
StudentID,SubjectID are the fileds that link Enrol to Student and Subject tables respectively.

To create a form for Student,Enrol and Subject is easy.
To add a new entry on form Enrol what can I do because I want the user to select from existing studentID/SubjectID.

[pbaldy]

As answered elsewhere:

One common method would be combo boxes that were bound to their respective fields in the Enroll table (control source property) but got their selections from the other tables (row source property).

cross posters

[jagguy]

I want to scroll through the records in the Enrol table via the form and also be able to enter a new record by selecting values as I said before.

Now what i did was place combo boxes on screen linked to fields in other tables and came up with one big mess?

[pbaldy]

Perhaps you can post the db? If your form is bound to the enroll table, you should be able to scroll or add records as desired.

[jagguy]

here is my DB with the enrol form which doesnt scroll through the enrol records.


I want to add records to enrol table via a form where the subID,STID are selected from existing values and you enter date.

Alsi i want to scroll through existing records on enrol form

[pbaldy]

I would expect the 2 combo boxes to be bound to their respective fields in the enrol table (stID and SubID).