When I change fields in a table then open a form, report or query it asks for the parameter. Why does it do this & how do I fix it?
I've had this problem when using 2003 & 2007.
Any help will be much appreciated!
Thanks!

How did you "change fields" in your table? Did you add or delete fields? Did you change the names of fields? My guess would be that the misbehaving forms and reports are based on one or more queries and you have not updated your queries to include the changes.

Let's say your table has a field named "StTime" and you decide, in order to make it clearer what kind of data it holds, to change the name to "StartTime." You also have a query based on this table with the field included. When the query runs, it expects data from your table for a field named "StTime" but won't find it; the field with that name no longer exists. The same thing would occur if you deleted a field from your table.

You need to go to the Queries Tab and open your query in Design View, and then make the appropriate modifications. Change the names of fields, if they've changed. Delete fields from the query if they've been deleted from the underlying table.

Also, it you add fields to your table, remember to add these to the query if you'll need to access them from a form or report. Otherwise, they won't show up the the Field List on the form or report.

Thank you so much!! That completely answers my question.
I was adding fields, deleting them & changing names.
It never dawned on me to go back into design view in the queries, forms & reports. I think for some reason I thought it should do it automatically.
Thank you again!!!