Access begginer - autoenter date/time when exiting a form

[Damir]

Hi everyone

I just started learning Access and I am building a simple database.

I have one form with 3 fields (ID, current date and current time). I'll be
using barcode reader to input numbers in ID field and date and time have to
be current, meaning the exact time when ID was logged. I also don't want to
allow changes in time and date field by user (i figured this one out -
properties/data/enabled-no).

My problem is that barcode reader reads the ID and also sends "enter"
command to computer, so new record is immediatly opened. How can I setup so
that current date and time are inputed before new record is opened, actually
when ID was read.

I managed with expression builders to populate date and time filed, but I
only managed to get date and time when new record was created, not when it
was 'closed' (ID was entered) and this is the time that I need.

Thanks in advance

 

[Dan Artuso]

Hi,
Set the form's cycle property to:
Current Record