To resolve this problem, create an index for the bound column in the lookup table.
To do this, follow these steps:
- Start Access 2007.
- Open the database.
- Find the bound column:
- In Design View, open Table A.
Note Table A represents a table that contains a lookup field. - Click the lookup field, click the Lookup tab, and then note the value in the Bound Column field.
- In the Row Source field, use the value that you noted in step 3b to find the name of the bound column.
- Create the index:
- In Design View, open Table B.
Note Table B represents a lookup table. - Click the name of the bound column that you found in step 3c.
- On the Design tab, click Indexes in the Show/Hide group.
- In the Indexes window, create an index for this column, and then close the window.