470,601 Members | 1,186 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,601 developers. It's quick & easy.

<< 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
Nov 12 '05 #1
1 4372
On 10 Apr 2004 18:25:52 -0700, Chuck wrote:
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


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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

31 posts views Thread by da Vinci | last post: by
2 posts views Thread by Donald Firesmith | last post: by
4 posts views Thread by Anastasios Hatzis | last post: by
3 posts views Thread by ajay2552 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.