Issue opening table. Access asking for parameter value

[bd528]

When opening a table, I am now being asked to enter a parameter value for "Lookup_Supply__ID.SupplyID".

The table I'm trying to open does have a field "Supply_ID" (one underscore), and there is a relationship from that field to another table.

I understand the issue I have is a little vague, and I can provide more information if that helps, but can anyone advise on how I can start troubleshooting this issue, as I have no idea what could be causing it.

Thanks in advance.

 

[NauticalGent]

It appears you are actually using a form to view the table and not using the navigation pane to view the table in "data sheet view"

Is this correct?

 

[bd528]

No, I'm using the pane

 

[NauticalGent]

Then the only thing I can think of is that you have a look-up value for one of the fields that does not exist. You will need to open the table in design view and check the look-up property for each field and make sure the look-up source(s) are valid.

If all that fails to correct the problem, try a compact and repair.

 

[The_Doc_Man]

Invariably, when you see the request to enter a parameter value, you have spelled the requested item as it is shown, but the "real" item as originally declared was not spelled that way.

Gent's suggestion about a possible spelling error in a lookup field is probably on-point. It is also an object lesson about why we don't recommend lookup fields. Instead, we recommend queries that perform a JOIN between primary and lookup-source. Everything that requires recordsets works with SELECT queries as well as tables, so you would not otherwise find a difference - but you can use the query builder grid to build this JOIN query (since you already know what the relationship should look like). If you use the query grid, you can drag-n-drop the correct fields and never spell any of them incorrectly.