query/report Q. linking to popup box. (1 Viewer)

[sha7jpm]

I have a report that runs off a query. the reports data is based on a simple criteria box that prompts the useer to enter a date.
the report then lists all the projects completed before and upto that date.

the problem is that the prompt date box, is not in itself an entity.

I want to put on the report the date entered by the user, but of course cannot reference to it.

is there any way to do this within the initial query? or maybe through the report itself?

at present the user has an empty date box on the report which they write in the date when they print it out!!!

any pointers?

ta
John

 

[ColinEssex]

In the query under the date field put the parameter [Enter Date] (or whatever)

then in the report header put the same parameter [Enter Date] in a text box control source

The date entered will now be shown in the report.

Col

 

[sha7jpm]

sorry colin, that does not work.

the box they enter the criteria date into is within the query itself, as soon as the query runs the criteria dissapeers becuase it is a temporary entity.

therefore there is no way to reference to that. as far as I can work out!

date column based on that criteria just brings up all the results so that cannot be used either!

 

[ColinEssex]

Hi

Sorry to be a pain on this, but it does work. I've just double checked it. I use it all the time.

In a text box in the report header. Control source of text box put

=[whatever text you have in the query]

the wording must be identical to what you have in the query parameter and Access will remember what is input and reproduce it on the report.

If you still have a problem I'll knock you up a sample later.

Col

 

[sha7jpm]

Success!

thanks for persevering!

no idea why it did not work the first time!

that is great am much obliged.

cheers

john