Form Refresh

[MikeG]

I have a simple query based form to log calls coming into our helpdesk. Now management would like exact times those calls were called in/logged so I've added a field called TimeRecorded. It's format is set to Medium Time with a default value of Now(). I completely forgot about lag time between calls so the problem I'm having is if the form is left open, the time won't be correct when calls are slow coming in. I want to refresh the form before entering the next log. I've played around a little with requery but I'm so sql illiterate, I'm still having trouble. I tried to requery just the TimeRecorded field with a separate button on the form but nothing happens. Any recommendations on the easiest way to accomplish this would be most appreciated. MikeG

 

[Elana]

The TimeRecorded field can be entered every time a call is logged in by setting the BeforeUpdate event of the form to:

me.timerecorded = now()

Then it will show the time the record was entered in the log.

 

[ghudson]

I would use the BeforeUpdate event of the form and have the TimeRecorded field = Time() to give you the current time as the record is being saved. If the save event is canceled, the time will not be saved because the record was not saved.

Is is possible for a user to modify an old record? That will have to be taken into account so that you do not update an old record with the current time.

HTH