Using a form to enter report critia

[LangAdel]

I have used the "use a form to enter report criteria" help in access, and everything works fine, except:

When I run the report I get my form up and I can enter the criterias. However when I press OK, instead of running the report, I get the standard Access "Enter Parameter Value" form whichs asks for the criteria once again. I can leave this form blank and the report runs as it is supposed to with the criterias I entered in my own form. So there is no need for the "Enter Parameter Value", but I cannot "turn it off".

Any help appresiated
Brian

 

[Cillies]

By any chance is your query a linked query, cause if it is you may have entered the parameters in the final query twice. Therefore you would need to remove one.

Else check the SQL of the query to see if your parameters are entered twice in the WHERE statement.

HTH
Cillies

 

[LangAdel]

Hi Cillies

Good ideas, but unfortunately that is not the case.

Brian