Using selection in one Combo to filter a second Combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having read nearly all of the threads, and advice on this subject I am still
unable to solve this.
I have two tables, tblTrainees & tblEducation.
tblTrainees contains trainee personal details, with primary key ID, &
tblEducation contains details of courses that the trainee is taking. Each
Education record has a primary key,EdcuationID, and also contains TraineeID.
In a subform record I am trying to select, in the first Combo, the name of
the trainee, and storing the trainee ID. in the second Combo I want to limit
the list to the courses the selected trainee is taking, and select the
appropriate course and store the EducationID.
So far all my attempts give me nothing to select in the second Combo.
I would appreciate help with this.
Am using Access 2000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Training Report 2
Training Database 4
Fields not linking between tables 3
HELP! a command button for a subform to open another form 4
Filter Combo Box Options based on other Combo Box Selection 1
cascading combo box 20
how to link tables 1
Undo a combo box selection 3

Back
Top