Beamer2010
Board Regular
- Joined
- Jul 8, 2015
- Messages
- 67
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.
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.