table not listed in the control source drop down menu

  • Thread starter Thread starter clau012
  • Start date Start date
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.
 
You want to use the RowSource property for your lookup table, and the
ControlSource property for the field you will populate via the combobox.
 
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.
 
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,
 
Back
Top