date pulled from unbound form

[zxmax]

Here is my scenario:
I have a form called "Date Range" which has 2 unbound feilds (one for the begining date, and one for end date) , i use this as a popup Form throught my database when i want to print my report, so i could filter specific date, this part works just fine,

On one of my reports, "end of year report" i want to show the date slected by the user in the "date Range" entered .. is there any i could do that, since these dates are not stored anywhere ?

I hope i was clear explaining my problem.. Thanks in adavance

 

[LittleSmudge]

As long as the popfrm is still open when you run the report.

Put an unbound text box control (txtTellDates) in the HeaderSection of the report

In the HeaderSection_Format event procedure put code along the lines of

txtTellDates = "This report is produced using the dates limits of :- " & Forms!popfrmGetDate!txtStartDate & " and " & Forms!popfrmGetDate!txtEndDate

If you want the info to appear in a different part of the report use the On_Fomat event for the section that you put the text box control into.

Rename the objects as appropriate.



'ope-that-'elps.





G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[zxmax]

Perfect, thanks