Andrew
asked on
Entering a saving a parameter for further use
In order to change one of the titles on a report, I enter a date value when I open the report. However, I want to store this date value so that I can use it in other parts of my report.
Can someone assist please?
Andy
Can someone assist please?
Andy
ASKER
Hi Jeff
Yes, having re-read my question it is far too vague so apologies for that.
What I am trying to achieve is to use my report as a 'Before' and 'After' report and by entering this date, I filter information differently according to where the exam date is compared to todays date.
So, I have an unbound textbox in my Report Header with the following:
and it is this 'entered' date that I would like to use in other elements of the report.
Note: this may sound strange but the actual exam date only appears as part of an overarching title in the format '2013-11-03_AAA_111'.
The other alternative would be if i could in some way extract the exam date from the title above.
I hope this makes it a wee bit clearer.
Andy
Yes, having re-read my question it is far too vague so apologies for that.
What I am trying to achieve is to use my report as a 'Before' and 'After' report and by entering this date, I filter information differently according to where the exam date is compared to todays date.
So, I have an unbound textbox in my Report Header with the following:
=IIf([Enter exam date (ddmmyy)]<=Date(),"Pre Standard Setting","Post Standard Setting")
and it is this 'entered' date that I would like to use in other elements of the report.
Note: this may sound strange but the actual exam date only appears as part of an overarching title in the format '2013-11-03_AAA_111'.
The other alternative would be if i could in some way extract the exam date from the title above.
I hope this makes it a wee bit clearer.
Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jeff
Many thanks for this, have adapted as you suggested and works a treat.
Regards
Andy
Many thanks for this, have adapted as you suggested and works a treat.
Regards
Andy
parameter prompt?
Inputbox?
Form textbox value
In any event:
Create a public variable in a Module:
Public dtmpubYourDate as date
On your code to open the report add this in:
dtmpubYourDate = [The same value you enter normally]
Then on the close event of the report do this:
dtmpubYourDate =""
JeffCoachman