Problem Changing Query Criteria

Steve_Bache

Registered User.
Local time
Today, 22:55
Joined
Mar 13, 2006
Messages
24
I was wondering if anyone could throw some light on a problem I'm having. I have a straightforward report - record source is a query. The query has some selection criteria which requires input at run time. This works fine ! (Why change this you ask ? I'm beginning to ask myself the same question- but hey !)

The problem occurs when I change the criteria in the query (original requested input of a parameter field - the new criteria points at a combo box on an unbound form). If I then run the report, it asks for 'both' sets of criteria (old and new ) !

I've tried copying both the query and the report (thinking that the original criteria are somehow being stored somewhere ), but I'm still getting the problem.

I guess I'm missing something straightforward but I just can't see it.

Cheers

Steve
 
Right click the title bar or the query when you have it open in design mode and make sure the "parameters" are removed as well....

Hope that helps
 
Thanks , there didn't appear to be any entry here but it now seems to be working !

Cheers

Steve:)
 

Users who are viewing this thread

Back
Top Bottom