combo box basic question...? Access 2007

[Graciela]

Hi everyone! I am having dificulty creating a combo box.
I have
-A table with memberID(prim. key-autonumber),name, address, etc.
-A second table named profession that gives the list of professions: doctor,
nurse, pharmacist, other). In the design I made the row profession as prim.
key.(so there is no autonumber).
-A third table that includes the memberID(from first table) and the
profession (from the profession table.
I want the combo box to show the selection of the 2nd table(doctor, nurse
etc), and put the info in the junction table (table#3.. this is the table
that brings info from#1 and#3).
I followed the wizard instructions, but... in the combo box I see the word
doctor repeated many times... so it takes me to the junction table. When I
choose the table that has the options... then the combo box is empty.
Do you have any suggestions? I truly appreciate it. Thanks

 

[Beetle]

Typically, you would have a form/sub form where the main
form is based on the Members table and the sub form is
based on the junction table, with MemberID as the Master/Child
link. In the sub form you would have a combo box that would
be bound to the Profession field in the junction table but would
pull it's values from the Profession table. The properties of this
combo box might look like;

Control Source: Profession
Row Source: Select Profession From tblProfessions
Bound Column: 1

 

[Graciela]

Hi Sean: Thank you so much for your response. I still cannot get it. I don't
know what I am doing wrong. I created the subform, and I can get the records
to show fine in it; I was also able to put it in the main form which is based
on the Members table. However, when I create the combo box... it shows empty.
I made sure that
1st... the memberID is in the Master/child link.
2nd... the property box looked like the one you suggested.
I feel I am getting so close! but I don't know where I am making a mistake...
Thanks
Graciela