How to Calculate difference of time to automatically update

[Beamer2010]

Greetings:

I created a database and on the form I have a some times I want calculated. For example what time was the order called in, and what time did we arrive onsite. I created a query that subtracts the onsite time from the called in time and I want the difference to populate a response time field. The VBA code is:

Private Sub Time_Click()

Me.Time = Round((Me.Onsite - Me.CalledIn) * 24, 2)

I want the difference to populate the time control or text box, but it is not happening even though I have the Event Procedure in the *******. Help I am not sure what I am doing wrong.

I would really like once the time is entered into the Onsite and CalledIn fields I would like the Time field to automatically populate with the difference in time. I hope that makes sense. Right now nothing is happening even when I click on the time field. Thank you for any assistance you can provide.

 

[alansidman]

How about using the Date Diff function. See this link for an explanation and syntax

https://www.techonthenet.com/access/functions/date/datediff.php


Then for the second time, put an afterupdate event and in that event, type me.requery.

 

[Micron]

Time is a reserved word and should not be used as a field or object name
Microsoft Access tips: Problem names and reserved words in Access