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: 
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.
I just ran into this same problem. The parameter mine was asking for what not even one of my field names. I finally figured out that I must have hit the space key in an empty field when I was adding some new fields to the table. I deleted about 10 empty fields to make sure I got all the mistakes and it cleared up my problem. I hope this helps!