Change the title of query

[meenctg]

I create a query by writing on criteria [ Enter your id : ]
When i run this query it shows Enter your id with the title Enter your parameter value. I wanna set the title as my choice.

How to will i do?

 

[boblarson]

I create a query by writing on criteria [ Enter your id : ]
When i run this query it shows Enter your id with the title Enter your parameter value. I wanna set the title as my choice.

How to will i do?

Create an input form and don't use parameter prompts.

 

[meenctg]

Create an input form and don't use parameter prompts.

i can do it. but here any process to custom title?

 

[boblarson]

i can do it. but here any process to custom title?

You cannot change the title bar of a parameter prompt. So, I said, use your own form for inputs INSTEAD of using parameter prompts. Open the form to put in the inputs and have a button to click OK and that will open the query (or form/report based on the query).

Also, the criteria would instead of [ Enter your id : ] it would be referencing the form's text box:

[Forms]![YourFormNameHere]![YourControlNameHere]

And the form's CAPTION property is where you would change the title of the form that would be popping up.

 

[meenctg]

tnx for response. i know the method. actually i wanted here other process or not.

 

[vbaInet]

As Bob has already told you, there's no other "process". You can ONLY do it with your own form.