CODEWITHSUNDEEP
ms-access
Ben H.
Ben H.

Reputation: 134

Lookup tables in forms not displaying correctly in tables

So, I had lookup fields on my tables. I have recently learned that this is a bad idea. So, I'm trying to convert them to lookup fields in the forms that fill those tables.

The lookup list is drawn from another table with the individual values. On the table, I went into design view under the lookup tag and changed "combo box" to "text box." The fields that were previously lookup fields now display the "key" of the item that was displayed previously in the field.

The form still shows the correct lookup value but the associated table no longer does it instead shows the number associated with the value and not the value. What do I need to do to fix this.

I guess my question boils down to not knowing how to link a lookup field in a form to a text field in a table.

enter image description here

enter image description here

enter image description here

Upvotes: 1

Views: 1188

Answers (1)

Sergey S.
Sergey S.

Reputation: 6336

You don't need to change your forms, just update your tables - change lookup from combobox to text box, you did this correctly.

Existing forms should work as usual, with comboboxes, settings for those comboboxes were copied from table settings and not liked to table settings anymore.

In new forms you'll need to do the same manually: after placing the field to the form convert it to combobox then setup correct Row Source, Column Count and Column Widths properties of combobox.

Upvotes: 2

Related Questions