Set Initial Value of Combo Box
Posted on 2012-09-21
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!