Access 2003 combo box not working properly

Access 2003 NEWBIE. I have a DB with 5 tables. I have 5 forms as well. On my main form I have a few comboboxes that pull values from a table, and they work great. I just added a new combobox to this form using the wizard, it asked me what table to get values from, I told it tblStudentName, and I told it to use StudentName field in said table. Now I open the form and I drop down this Student name field and sure enough all the names in the table show up. So far so good, but I notice when I go into design view it sayd the field is UNBOUND. So I go into the prop for that field, and in the control source dropdown I do not see the field StudentName showing up to pick. Row Source Type says Table/Query, and the Row Source says tblStudentName. But when I drop down Control Source, StudentName is not a choice. The reason I need to fix this is I have an ADD RECORD button that clears the form and allows a new record to be fiilled in, and this Student Name field never clears, and I assume its because its UNBOUND. Its almost like the field prop doesn't see the tblStudentName despite me telling it that is the table to use.
thx experts...BobR
Who is Participating?
Are you trying to add a student name to a table field? Which table field? Probably, you'll want that table to be the record source for the form that the combo box is on.
bobrossi56Author Commented:
Sometimes I just need a slap in the head to get my brain engaged. I did not have a field StudentName in the table the form was adding to. DUH!!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.