parameter message

A

Alan

Hi folks,

In my query, I created a field to pass a value into to use for a calculation
elsewhere. Everything works fine but when you run the query, it comes up wtih
the name of the field I created which isn't very descriptive. I'd like to
attach and description/message to the prompt so that it gives the user a
better idea of what that parameter box is asking.

i.e.

#OTHours: [#OTHrs]

When the [#OTHrs] field box pops up, I'd like to actually attach a
description of "# of OT hours this month:"

Thanks,
 
D

Douglas J. Steele

Try using

#OTHours: [# of OT hours this month:]

If that's not what you want, another alternative is to open a form that has
text boxes labelled as you want, then put a button on that form to launch
the query. You'd point to the text boxes on the form using
Forms!NameOfForm!NameOfControl
 
A

Alan

Thanks Douglas. I'll try that.

Alan

Douglas J. Steele said:
Try using

#OTHours: [# of OT hours this month:]

If that's not what you want, another alternative is to open a form that has
text boxes labelled as you want, then put a button on that form to launch
the query. You'd point to the text boxes on the form using
Forms!NameOfForm!NameOfControl

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Alan said:
Hi folks,

In my query, I created a field to pass a value into to use for a
calculation
elsewhere. Everything works fine but when you run the query, it comes up
wtih
the name of the field I created which isn't very descriptive. I'd like to
attach and description/message to the prompt so that it gives the user a
better idea of what that parameter box is asking.

i.e.

#OTHours: [#OTHrs]

When the [#OTHrs] field box pops up, I'd like to actually attach a
description of "# of OT hours this month:"

Thanks,
Click to expand...
Click to expand...
 
Top