By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,145 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

parameter errors after changing the table

P: 2
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!
Nov 6 '08 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
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.

Welcome to Bytes!

Linq ;0)>
Nov 6 '08 #2

P: 2
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!!!
Nov 6 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Nov 6 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.