'quick' vb/access question :)

[streetster]

hopefully the solution is easy, and doesnt involve ADO or anything complicated...

basically, i am doing a timetable system, and i have written out a timetable in table (fields like, day, period, lesson, studentID), and i now have made a form with the days/periods on it, all i want is for the user to be able to choose the user from the drop down (done that bit), which then runs a query to list what lesson a particular student has on a particular day & period, based upon the id in the drop-down box.

SELECT [tbl_timetable_student].[Subject]
FROM tbl_timetable_student
WHERE ((([tbl_timetable_student].[Student_ID])=prototype.gStudentIDBox) And (([tbl_timetable_student].[Day])="Monday") And (([tbl_timetable_student].[Period])="Period1"));

where prototype.gStudentIDBox is a global variable defined by the value in the drop down box.. but when i try it like that, it asks me to input the parameter "prototype.gStudentIDBox". which isnt useful...

any ideas folks?

mark

[Raz316]

can you not just call the entry from the drop down straight off, instead of using a variable?

[streetster]

hmm, this should be in the programming section as i just went to look for it there and realised it wasnt...

anyhow the student_Id is taken from a different table, and i dont see how i can make it work on the form, as the control source of the form is the timetable table, rather than the student table... might have another fiddle tho.

cheers
Mark