Creating look up tables

Hi Sarah,

Thank you for your question and welcome to the forum.

I assume the lookup values have been attached to a field in a table?

If so, open the table in Design view and select the field from the field list. At the bottom you should see a Field Properties Window.

Select the Lookup tab and click at the end of the Row Source field after the last lookup value entered. Enter a semi colon(;) followed by the new item for the list.

Alternatively do the Lookup Wizard again from scratch to include the full list.

I hope this answers your question. Let me know.

Regards

Simon