How do i lock (?) a field ?

[noobie1]

Name: msft access lending library.PNG  Views: 25  Size: 14.5 KB  ID: 51092" class="thumbnail" style="float:CONFIG" />

I am currently trying to build a simple lending library using a barcode scanner to scan 1. member id barcode, 2. radio barcode, 3. and date/time stamp.
I can't figure out how to make the selection go down to the next blank cell after scanning the first two items and not replace the date/time. Is it possible to lock the field so no entry is possible after the time/date has been recorded ? Also is there anyone who can help me build this lending library ? TIA.

[June7]

Can't do this in table or query. Build a form where you can have code and properties you can manage.

Have you seen the MSAccess Lending Library sample database template? https://support.microsoft.com/en-us/...8-1afcfc91a9cb

[ranman256]

in the FORM:

sub form_Current()
dim bLock as boolean

bLock = not isnull(txtDate)

txtFld1.locked = bLock
txtFld2.locked = bLock

end sub