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

Report prompting for deleted fields

P: 1
Hello everyone,
I am new to this Forum and hoping I can get some help. I have a report that displays the results of a query. But everytime I run the report it prompts me for parameters of certain fields that used to be on the report but have been deleted. The parameters are not on the field list and not on the querry.
Any ideas?
Mar 9 '07 #1
Share this Question
Share on Google+
3 Replies


P: 9
You either have a control on your report which has its controlsource set to what is being prompted for or it is somewhere in your query or report recordsource, have a 2nd look ;)
Mar 9 '07 #2

NeoPa
Expert Mod 15k+
P: 31,342
There is a little used, but very handy tool called the Documenter (Tools / Analyse / Documenter) that can show all sorts of information about an Access object.
If you run this with just that one report selected and select all the options within that, you will get an RTF file (Publish with Word) that you can search for the items you've 'lost'.
Mar 10 '07 #3

ADezii
Expert 5K+
P: 8,619
Hello everyone,
I am new to this Forum and hoping I can get some help. I have a report that displays the results of a query. But everytime I run the report it prompts me for parameters of certain fields that used to be on the report but have been deleted. The parameters are not on the field list and not on the querry.
Any ideas?
This can also happen when you have Fields defined within the Sorting and Grouping Dialog Box that were subsequently deleted. In Reports Design View, select View ==> Sorting and Grouping, and check if there are any Fields that were deleted.
Mar 10 '07 #4

Post your reply

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