help with automatically updating a parameter query

  • Thread starter Thread starter FrankieNap
  • Start date Start date
F

FrankieNap

I am quite new to Access, but have been teaching myself along the way.
I am putting together a database for my students and am having some
difficulty making my test assigner. Here are 3 tables of my database:

1. AT tutor student database : contains contact information about my
students, including a unique Student ID for each student.
2. SATITest : includes information on all of the tests each of my
students have already taken (including a StudentID and a TestID)
3. SATID : includes names of all of the available tests (TestID)

I have created an unmatched query which matches Tests taken from
SATITest to SATID and finds tests that each individual student has not
yet taken. I have set the StudentID as the parameter for the query.
I assign tests in a form in AT tutor student database using the query
as a drop down list to show availabletests, but instead of typing in a
new student ID each time I want to assign a test, I want the StudentID
to update automatically when I go from student to student so that the
query displays the available tests for each individual student.

Any advice?
Thanks,
-frank
 
don't use a parameter query as the RowSource of the combo box ("drop down
list") control. instead, set the criteria of the StudentID field in the
query to

Forms!FormName!StudentID

replace FormName with the correct name of the form that the combo box
control is in, of course. next, add code to the form's Current event to
requery the combo box control's RowSource, as

Me!ComboBoxControlName.Requery

hth
 
Back
Top