Microsoft Access Continuous Form Question - Unbound Fields
Posted on 2011-09-07
My application uses a continuous form named "frmSVR" which is based upon a query. The query includes all records from the SVR table that have a status of Active. As a result, when I open the form I see 10 continous forms.
One of the fields displays the date and time that the SVR was requested. I would like to add a second field which calculates how many minutes it has been since the SVR was requested.
I created an UNBOUND field called HobbsTime and added the following code to the ON_Current event procedure.
Me.HobbsTime = DateDiff("n", Me.RequestDate, Now)
I was hoping this would calculate the number of minutes since the SVR was created and display such on each form, however, every form is display with the same calculation.
9/3/2011 3:05PM 23
9/3/2011 4:30PM 23
9/5/2011 2:22PM 23
I suspect I need to change the name of the HobbsTime field in each form but don't know how.