Form records to appear in order as they are entered

[aldeb47]

I have a form: MTCPointsfrm

I enter the records one at a time. How can I make the form records show up in the order they are entered and how they appear in the table? The first record I entered might show up as #10 on the form when I want


it to be #1. The table key is an auto number.

[Rod]

Add a timestamp to the record. Do this just before it is updated (saved) for the first time. Then when displaying records, order by timestamp. OK the timestamp relies on the date and time being correct in your PC if you use the Now() function.

Put something like this into the form's BeforeUpdate event:

If IsNull(Me.varTimeStamp) then
Me.varTimeStamp = Now()
End If

[Rod]

Er ...

just reviewed my post. Probably varTimeStamp should read dteTimeStamp or dtmTimeStamp.