Set Default value of text box field in a form to a global variable

[Guest]

I have a form which an employee uses to enter their info so they can gain
access to my database. I have code which grabs he user's NTUserID or login
name and uses it to grant access to the database. Those not in the database
need to enter this ID in a form that pops up.

What I want to know is if it is possible to default the value of the proper
field in my Add User form to a global variable which contains their username.
This would elimnate and error on the user's part because there are about a
bajillion different user names for each person at my company haha. I can't
figure if this is possible or not.

Thanks in advance!

 

[Guest]

Is anybody able to access you database? because if their NTUserID is not
valid then they can add themselves, so what is the purpose to try to restrict
acces to the file?
Looks like you are using a network, it will be easier to grant access to
your file(s) based on the network group policies.

 

[Guest]

By adding themselves, they can gain read only access. The potential number
of users is quite large, which is why i can't populate the database with
everyone who might use it. I think i've resolved the problem tho by setting
teh value on form load Me.NTUserID = userid.