Access 2003 combo box not working properly

Posted on 2011-10-02
Medium Priority
Last Modified: 2012-05-12
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
Question by:bobrossi56
LVL 12

Accepted Solution

pdebaets earned 2000 total points
ID: 36900351
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.

Author Closing Comment

ID: 36900510
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!!!!

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question