Adding Look-up Table/Column

  • Thread starter Thread starter MMC
  • Start date Start date
M

MMC

I tried adding a look-up table/column for a form I'm doing. I used the wizard
for it and everything looks ok except that when I click on the column,
there's nothing it in.
I'm trying to add the following on our form:

Comorbidites : DM
HTN
CVA
MI

Is there anything I'm doing wrong? I created the table and used the wizard
for my Comorbidites column.

Thanks
 
Is this a *lookup field* in a table, or a combo on a form based on values
from a table containing the lookup values? The latter is what you want.
 
Check the properties of the combo box, on the "Data" tab. Look at the "Row
Source" of the combo box. If you click on the "...", you can look at the
query that the combo is based on. Make sure that the correct values show up
in this query when you view it in datasheet view.

If not, add the correct field from your table, and make sure it's visible.

If the source is correct, then check (in the properties of the combo box)
under the "Format" tab, the "Column Count" and "Column Widths".
 
Back
Top