Unexpected result from a dropdown control

[George]

Good Day all,



On a form "QueryTimeTable" I have a control "Course" whose data source is from a field "CourseName" in a table "Course".

Using the Control Wizard I was able to setup the populating of the "Course" control.

When I click on the dropdown arrow on the control I can see clearly the list of name spelt out. However when the form is closed and the table is check for the selected name; instead of the string name there is the Course ID number.

Can anyone explain this unexpected results and guide me how to correct this error?

The code generated by the wizard in the row source field of the property sheet is:

SELECT [Course].[ID], [Course].[Course Name] FROM [Course] ORDER BY [Course Name];

Clearly ID is selected, but I did not include it in the selections by the wizard. When I remove it the dropdown control goes empty.

The bound column in the property sheet is set to 1. I have experimented with other number without success.

[orange]

Check the format of the combo (dropdown). The wizard has probably hidden the CourseID.
If timeTable is a separate table then Course and TimeTable are likely joined on CourseID.

[George]

Thanks for your response.
timetable is separate and course in a field in timetable so they cannot join.

I did check the format but not sure what to look for.

[George]

Actually I checked and they are not joined.

[orange]

Please post a picture of your tables and relationships (relationships window).
Also could you explain how Course and Timetable are related in plain English?
Perhaps a brief overview of what you are trying to do would help with context.

[John_G]

The bound column in the property sheet is set to 1.

I think your problem is there. Normally, column references in combo boxes are zero-based, that is, the first column is column(0).

The bound Column property is an exception - the first combo box column is column 1.

If you want the course name to be stored to the table, set the Bound Column to 2.

[George]

Thanks you all.

It's working