Append Query transfers ID rather than Name

[TheHarleygirl2005]

I have a form with an unbound combo box where I select a Course Name from a table. After I input all the info I have a Command button that I select to run the Append Query and transfer the information to another table. I have tried this with a combo box and a list box. No matter what I do, the course name shows up on the form, but when I append it to the table the CourseID shows up instead of the name. Can anyone help I can't figure out what I am doing wrong.

[June7]

You aren't doing anything wrong. That's how it should work, assuming CourseID is the primary key field.

The CourseID is the actual value of the combobox.

Why use APPEND query? Why not use a form/subform arrangement?

[TheHarleygirl2005]

I set it up as an append query because I have a list of employees with a checkbox. I enter the course information (Date, Course, Course type, etc) then check off the people who attended that course and append it to another table where I use that information to generate reports. I would prefer the Course Name appends to the table, but I can work with the CourseID. Just thought I would ask to see if it was possible to change.

[June7]

It is possible. Reference the combobox column that has the course name. Column index begins with 0.

Me.combobox.Column(1)

Are you duplicating data? Should retrieve related data in query that joins tables, not replicate the data.
If CourseName is the saved value then it should be the primary key.

[TheHarleygirl2005]

Thanks, that's what needed.