Error - You have chosen fields from record sources which the wizard can't connect

[graycam]

Hi:

I'm trying to get a populated drop-down to appear in a form, but I
receive the error "You have chosen fields from record sources which the
wizard can't connect".

To simplify ....

2 tables: tblStudents & tblColors.
tblStudents = two fields -> studentID studentName colorID
tblColors = two fields -> colorID colorName

1 query: qryColors which simply selects the color name from the colors
table.

Relationship between color table & colorID field in tblStudents is
fine.

I want to have a form which shows the student's name, and their
favorite color. But I'd like the color to be a drop-down with all
colors possible (but the appropriate color for that student selected).

My form (using the wizard) includes the field StudentName from
tblStudent and then I try to select the qryColors which will select the
colors. I receive the error "You have chosen fields from record sources
which the wizard can't connect"

How do I get a query to display in a form?

Thanks!
Cam