Deleted Parameters Continue to Prompt for Values

[dougdrex]

Using Access 2010



I have a query where I had set up the Criteria line to prompt for beginning and ending dates. My boss has now requested that I just prompt for beginning and ending months and year. So I deleted the column from the query that contained the prompt for beginning and ending dates, and added columns for the month and year (along with the appropriate prompts). However, now the query prompts for beginning and ending dates ALONG WITH the first and last month and year.

Why is Access still prompting me for the beginning and ending dates, and how can I stop it?


Thanks!
Doug

[pbaldy]

What is the SQL of the query?

[darshit_goswami]

u should check all dependencies well.. make sure it doesnt conflict anywhere.