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

 

[Bob Miller]

You don't need the query. Place a combo box on the form whose Control
Source is ColorID form tblstudents and Row Source is tblColors with
ColorID as the Bound field.
When you select a color from the drop down the tblColors ColorID will
be placed in the tblStudents ColorID.
The reason you were getting the error is that your were attempting to
put text (color name) in a number field (ColorID).