Remove "Enter Parameter Value"

[ssatech]

Hello,
Could anyone tell me how to remove the "Enter Parameter Value" in the popup dialog box of a parameter query? Any help on this would be appreciated.

 

[KenReay]

Hi

One way

Make a form to get the user input (parameters), change the criteria in the query to be Forms!MyForm!MyForm type syntax (using your own form and control names or course in place of the My.. names I have used). The builder will guide you through this. Provided the form is open when the query runs, no prompt box will appear



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ssatech]

Hi Ken,
Thanks for the reply, but I am not sure what you mean by making a form to get user input. Do I base this form on the query with the criteria referring to this form? I am not clear on this. Could you possibly walk through the process for me. Greatly appreciated!

 

[lespaul]

Change the query to:


SELECT Something FROM Somewhere WHERE SomethingElse = [Please enter SomethingElse to Search for:]

This will show the user a prompt box that says:

Please enter SomethingElse to Search for:
[_________________]
[OK]


Leslie

 

[ssatech]

Thanks for the reply Leslie, but this still does not remove
the "Enter Parameter Value" on the dialog box bar....Any ideas?

 

[KenReay]

Hi Create an unbound form

On the form put as many text boxes as you need to collect the parameter(s)

Put a button on the form to run the query, (or report if it is a query for a report), the wizard will guide you through this

Do what I said in my first post

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ssatech]

Ken,
I did not understand your first post. I did what you said on the second post and it works. Thanks for the help mate.

Cheers!