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.
Code:
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