Display name of a parameter query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This my sound silly but I just have not been able to figure it out. I built a query to run on my table and everything works great, My problem is the popup box. Is there a way to change the display name of the popup box?

at the present time it displays the expression " [Forms]![Tracking]![Store] ", I need it to display " Enter Store Number
Is it possible to do this

Please help
Thanks
Melvin
 
This my sound silly but I just have not been able to figure it out.
I built a query to run on my table and everything works great, My
problem is the popup box. Is there a way to change the display name
of the popup box?

at the present time it displays the expression "
[Forms]![Tracking]![Store] ", I need it to display " Enter Store
Number " Is it possible to do this?

Please help, Thanks, Melvin
Click to expand...

Melvin,
It displays [Forms]![Tracking]![Store] because it is supposed to be
getting it's parameter value from the control named [Store] on the
form named [Tracking]. If you are using the form to enter the
parameter value, you should not be getting any prompt at all. The form
must remain open when the query is run.

However, if you do not wish to use a form to enter the parameter
value, replace the [Forms]![Tracking]![Store] with
[Enter Store Number].
Make sure you place the prompt within the brackets, as I have.
You will be prompted each time you run the query.

Using the form is better.
 
Back
Top