Opening table shows "Enter parameter value"

Question

I've done something to my Access database, and now when I double-click a table (all Access Objects | Tables) it puts up the "Enter Parameter Value" dialog. The parameter that it is asking for is of the form TableName.ColumnName, and ColumnName is indeed a column in TableName, but TableName is NOT the table I am opening. As it is a table I am opening, not a query or report etc., I have no idea what is causing this or what to do about it. If I just hot OK it seems to then open the table fine, but I'd like to fix it if I can.

Answer 1

Open the table in Design View and then open its property sheet. Make sure you examine the table's property sheet (it should say "Selection type: Table Properties" just below the "Property Sheet" heading).

Look for [TableName].[ColumnName] in one of those properties.

I was thinking of the Filter and Order By properties; you confirmed it was in the Order By.

That can happen when you apply a sort option from the ribbon and then save that sort with the table's design.