Lookup in a query???

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

Guest

I was wondering whether for a parameter query, is it possible to obtain my values from a lookup box instead of typing them in.
Eg: I want to find the grades of this particular student. instead of typing in the student ID or name, is it possible to have a lookup box containing all the names of the students where i can choose from

Thanx for helping!!
 
Yes, it is possible; you can put your combo on a form, and a reference to it
in the query criteria line.
Assuming your form is called frmSelection and the combo is called
cboStudent, then the criterion in the query should be:

Forms!frmSelection!cboStudent

As long as the form is open when you run the query, it will do what you
want.

HTH,
Nikos

Sad said:
I was wondering whether for a parameter query, is it possible to obtain my
Click to expand...
values from a lookup box instead of typing them in..
Eg: I want to find the grades of this particular student. instead of
Click to expand...
typing in the student ID or name, is it possible to have a lookup box
containing all the names of the students where i can choose from.
 
Back
Top