table not listed in the control source drop down menu

C

clau012

I created 2 tables. 1 table called issues, the other called worktype.
I then created a form and I want to add the Worktype in there as a
combo box linked with the Table Work Type. So the user can go on the
form and they will have a pull down from the Work Type combo box and
select option 1 or option 2. I'm trying to bind the Work Type combo
box to the Work Type table, but Work Type is not listed under the
control source when I right click on the Work Type combo box. Please
assist.
 
S

SusanV

You want to use the RowSource property for your lookup table, and the
ControlSource property for the field you will populate via the combobox.
 
C

clau012

That's just it. In my ControlSource field, when I select the pull down
arrow, I dont see the table listed that I want to be the ControlSource.

Thanks.
 
S

SusanV

Again, you don't select a TABLE as the CONTROLSOURCE - that property is
populated by a filed in the table which is the form's recordsource. The
Lookup table is defined by the ROWSOURCE Property after you set the
RowSourceType to Table/Query.
Hope that's clearer,
 
Top