Recording data history

[Paradigm]

I have a continuous form which is used to record the current location of
staff. The form records time, location, notes and a category.
I want to add this record to a history table so that whenever someone is
checked in or out the data is recorded. The problem is I do not know when to
do this since the data can be entered in any order so the afterupdate event
on any of the fields will not get all the fields or will create multiple
records.
For example, if someone checks out and I add a new record with the staffid
and time, and then they complete the location field the created record will
not have the location.
alec

 

[Guest]

Rather that let your users edit and/or add a new record in the continuous
form, you might consider having a seperate form open up where the updating or
data entry would occur. This way you can have more control over the events
and the actions of the user.

It has been my experience that trying to maintain good control over data
entry and then taking appropriate action is difficult to do when users are
allowed to make any data entry in a continuous form.

 

[Paradigm]

The form is often used by a receptionist who simply keeps it open and then
knows where staff are (other users can also open it to record or check on
staff movements). When people arrive in the morning they all arrive within a
few minutes and are simply checked in. Similarly when they leave at night.
Also, in a busy office, the records are changing minute by minute if not
second by second. It would be too much of an interuption to have to open
another form and then click OK everytime.
Alec