referencing text boxes in tabular view

[TheTrainMan]

I want to show on a tabular form the date difference between todays date and some date in the past, I also need this interval to be printed onto a report (and exported to file as well). Do I need to create a field to hold the date difference or can it be calculated whenever the form/report is opened?
How do I get all the dates in the tabular view to show their date difference???

I have used an event procedure with OnOpen to fill one text box with a value, but I don't know how to reference all the different text boxes shown in tabular view.

Please help!!!

 

[Rich]

Put the calculated field/s in a query, base the form and report on the query

 

[TheTrainMan]

Ok, so I need to use a field to store the date difference... but how do I put the date difference (or anything for that matter) in all the fields??

If I have a table "DateTable" with Fields "BeginDate" and "DaysBetween", what do i need to have in the query and how is this referenced in the form/report?? Do I need to update the field using OnOpen???

 

[TheTrainMan]

Sorry, was being thick!! Didn't know how to do calulated fields in queries... done it now, thanks for the pointer!