PopUp box for part of formula entry into query?

[rlarson]

Happy New Year Everyone!

I have a very simple select query with one field that calculates age, using this formula:

Age (in Days): #12/27/2004#-[post date]

I would like to be able to have a PopUp box that would let the user specify the date in the first part of the formula: #12/27/2004#, each time the query is run. An additional idea would be to enter it once in the popup box, and then let the popup default to the most recent date used. So, the popup box would permanently update the formula until the next time the user enters a new date.

Does anyone have any tips for how I would go about doing this? Thanks!

 

[Andrew Fergus]

Hi, in answer to this bit :

I would like to be able to have a PopUp box that would let the user specify the date in the first part of the formula

try changing your formula to this :

Age (in Days): [enter age calculation date] - [post date]

I'm not sure how you would get the query to remember the 'age calculation date' other than by storing that value in a table. If the table had nothing in it then the query would ask for a date, otherwise it would use the value in the table. This would require quite a bit of set up and would suit a database that is 'form driven'. Other than putting my idea 'out there' for others to consider, I can't help with the 2nd part.

HTH, Andrew.