Inspect expressions in a table
If Access displays the Enter Parameter Value dialog box every time that you open a table, the incorrect expression is most likely in the Row Source property of a Lookup field in that table.
Right-click the table in the Navigation Pane, and then select Design View.
To determine if a field is a Lookup field, select the field name, and then under Field Properties, select the Lookup tab. If the tab contains a Row Source property box, then the field is a Lookup field. Examine the Row Source property. If it contains an SQL statement, then one of the identifiers in the statement may be incorrect, and causing the Enter Parameter Value dialog box to appear.
Note: A table can have multiple Lookup fields, so be sure to check the Lookup tab for each field.
Encontrado aqui da Microsoft. Isso pode ajudar você a tomar a direção certa.