Table

[Trilback]

I have a table in my current work database (table is linked to another access db) that I deleted a field that I no longer need. I am editing my database some. One of my forms I want records source to be a query and not the table so I created a query, now when I change my record source to the query it acts likes that field I delete still exists ask I get the "Enter Parameter Value" dialog box on that field that is not in the table or the query anymore. What would cause that??

 

[jdraw]

It seems that something in your code or queries is/was using the field you deleted.

 

[wire_jp]

jdraw is right. You can check your query and switch to design view to see if there are fields which start by "Expr1"

 

[Trilback]

Thanks for the help. It was in another form that was not pointing to that query but it works now.