i've got a table and one of the fields is staffID.
i've got a UDF called WindowsUserName which gets the username from windows api. (NOT the lousy environ function - only noobs do that) hahahaha
i've got a table that matches staffID with windows username.
in my default value for this staffID field, i want the.... ta da! staffID!
so i'm thinking 2 ways i can do it
2) Dlookup( blah blaah blah where username = WindowsUserName)
i just can't seem to figure out how to use functions in default values.
i tried =WindowsUserName but it gave me ="WindowsUserName"
tried Eval("WindowsUserName") and =Eval("WindowsUserName") but to no avail = (
hrmm i'm not sure how to do it. could yall help me guys?
thanks so sooo much!! = ))