code for Location

[p-rat]

We have more than one location that is entering data into a form. The
'yard' field is where the location would go. I can I code it to where
the system knows where the person is entering information. Basically,
I can I have Access recognize where the data entry clerk is an
automatically have the 'yard' field filled?

 

[ruralguy via AccessMonster.com]

Why not use the local computer name to determine location?
http://www.mvps.org/access/api/api0009.htm

 

[Daniel Pineault]

create a table where you enter each user's userid (login) and yard value.

then you simply code it to check the currentuser() value and perform a
dlookup in the table to populate the yard control accordingly.