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
bobrossi56Asked:
Who is Participating?
 
pdebaetsCommented:
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.
0
 
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!!!!
thx
0
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.