Set Initial Value of Combo Box

Posted on 2012-09-21
Last Modified: 2012-10-01
This may end up being more of a design problem than a combo box issue.

I have an unbound form that can be used to enter new data into a table or to modify existing data in that table. The record for the form is selected from a combo box (not the problematic one) of graduate student names. Once the student/record has been selected, I want to populate the other controls on the form from that record.

My question is about other combo boxes on the form. For example, one combo box allows the selection of a thesis advisor from a list of about 15 names from another table. If the record field for the advisor in the student table is empty or blank, no problem. However, if a name was previously selected and stored in the table, I'd like to show that name as the default in the combo box, but still allow the field to be changed by selecting another faculty name from the combo box. I'm stumped about how to do this.

Like I said, maybe this is a design problem. Would it be better to use a bound form?

Thanks in advance!
Question by:Gazaway
    LVL 119

    Expert Comment

    by:Rey Obrero
    here is how i'll do it.
    * create a bound form
    * in the bound form add an unbound combo box
      - use this  combo box afterupdate or change event to filter the records of the bound form
      - find the  record that you have selected from the combo box...

    Author Comment


    <whoosh!> That's the sound of your explanation going over my head! Not your fault, just my inexperience. Would you elaborate please? I'm unclear as to what is meant by filtering the records and finding the record from the combo box. What records are these? I've already found the record for the student table by the time we get to the faculty combo box. Your answer may well solve my problem, but right now I don't understand how it would work.
    LVL 119

    Expert Comment

    by:Rey Obrero
    so we understand each other, upload a copy of the db..

    Author Comment

    Sorry for the delay. I didn't work on this over the weekend. The database is rather large and has some confidential information in it. Let me see if I can create a subset of the data and tables to upload.

    Accepted Solution

    Again I apologize for being slow to respond. This database is only one of many responsibilities I have and I can't always get to it as often as I'd like.

    I decided to reorganize the form, eliminating the need for an answer to this question.

    Author Closing Comment

    I worked around the problem by reorganizing the form so that this issue didn't arise. I'd already spent quite a bit of time working on it before posting my question here and needed to move on. I'm giving myself a "B" because it's a workaround, not an actual solution to the problem.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID  ( Here (http…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    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…

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now