<< HELP>> Enter Parameter Value in query

I have a query that uses the query with the critera set to [Enter
Customers Last Name]. We I run the query the msgbox pops up asking for
the name information to be entered, but on the top (blue background)
of the message box it says" Enter Parameter Value ". Is there anyway
to change this to something that is not as generic.

I appreciate any help you can give.

Thanks
Chuck

re: << HELP>> Enter Parameter Value in query

On 10 Apr 2004 18:25:52 -0700, Chuck wrote:
[color=blue]
> I have a query that uses the query with the critera set to [Enter
> Customers Last Name]. We I run the query the msgbox pops up asking for
> the name information to be entered, but on the top (blue background)
> of the message box it says" Enter Parameter Value ". Is there anyway
> to change this to something that is not as generic.
>
> I appreciate any help you can give.
>
> Thanks
> Chuck[/color]

No!
But you can use a form with a control on it to enter the parameter and
avoid the prompt entirely.
Change the query parameter from
[Enter Customers Last Name]
to
forms!FormName!ControlName
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.