Field Lock on a form

[ARN]

I have form consist of few text boxes. The access file
isused by three users. What i am looking for is some kind
of lock that.

Example . txtbox1 and txtbox2 - for user 1
txtbox3 and txtbox4 - for user 2
txtbox5 and txtbox6 - for user 3

i want to resctrict user 1 & 2 entering data in txtbox5 & 6
which is allocated for user 3. I want to do this without
using a user name and password. Is there any way. cann it
be done on base of windows log on name.

please help.

 

[John Spencer (MVP)]

Try the code at
http://www.mvps.org/access/api/api0008.htm

To see if that gives you the value you want to use.