Access 2003 combo box not working properly

Posted on 2011-10-02
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

    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

    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!!!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now