Combo box selection for query

[reecejd]

I'm new at Access 03. I have a combobox that is sourced by a table, Rowsource property is:

SELECT Classes.TableID, Classes.ClassID FROM Classes;

The name of my combobox is "ClassCombo".

I'm trying to generate a report based on my combobox selection, but I can't reference the value of the selection. The query tied to my report has the following SQL:

SELECT ClassesForInstructors.ClassID, Instructors.InstructorID, Instructors.FirstName, Instructors.LastName
FROM Instructors INNER JOIN ClassesForInstructors ON Instructors.InstructorID = ClassesForInstructors.InstructorID
WHERE (((ClassesForInstructors.ClassID)="[Forms]![School]![ClassCombo]"));

I'm trying to grab the "ClassCombo" value as input to my query, but it's not working. What am I doing wrong?

Thanks!

 

[PHV]

Get rid of the double-quotes when referencing the combo:
WHERE ClassesForInstructors.ClassID=[Forms]![School]![ClassCombo]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[reecejd]

Thanks, but no luck. I forgot to mention that this query works fine with a textbox input.

 

[daidohbendigo]

Have you tried putting the row source as

SELECT ClassesForInstructors.ClassID, Instructors.InstructorID, Instructors.FirstName, Instructors.LastName
FROM Instructors INNER JOIN ClassesForInstructors ON Instructors.InstructorID = ClassesForInstructors.InstructorID

and in your command to open the report

DoCmd.OpenReport "Your Report", acViewPreview, "", "ClassesForInstructors.ClassID=[Forms]![School]![ClassCombo]", acWindowNormal

 

[reecejd]

Got it fixed! Thanks for all of the help!