code for Location

  • Thread starter Thread starter p-rat
  • Start date Start date
P

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?
 
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.
 
Back
Top