Can a user enter a value for a txt box on a rep as it opens

M

mcgj

I am creating a report on which I want the user to be able to enter any date
that he sees fit as the report opens. Is there a way for me to set the
proper properties so I can have this happen?
 
R

Rick B

Not sure. You don't explain what type of data or if it will be used in any
way. If you want to limit records on the report based on the user's input,
then you would use the imput in your query. If you want to display the
user's input, then you would do so in a text box on the report.

If you expect a detailed answer, you'll have to post a detailed question.
 
M

mcgj

Ok here is the deal:
I want the user inputted date to appear in an unbound text box on the
report. I don't want it to limit the records I just want to have what the
user types into an Input dialog box to appear on the report. I have found
that if I type just a number into the control source property I can get the
program to pop up an input box as the report opens then you can tpye in the
information and it will appear in the txt box. I would like the dialog box
to have a more descriptive explanation on it something like "Enter Date"
rather than "2".

Specific enough?
 
M

mcgj

That works!! It seems like I get inconsistent results when I do that,
sometimes it will look for a field name "5/10/2005". Not sure why or what
the deal is... Thanks for your help Rick.

mcgj

Rick B said:
Just build an unbound text box and put the following in it...


=[Enter Date]



--
Rick B



mcgj said:
Ok here is the deal:
I want the user inputted date to appear in an unbound text box on the
report. I don't want it to limit the records I just want to have what the
user types into an Input dialog box to appear on the report. I have found
that if I type just a number into the control source property I can get the
program to pop up an input box as the report opens then you can tpye in the
information and it will appear in the txt box. I would like the dialog box
to have a more descriptive explanation on it something like "Enter Date"
rather than "2".

Specific enough?
Click to expand...
Click to expand...
 
Top