Multiple default values

[dsmoot]

I thought this would be an easy problem but maybe I'm missing something. I am creating a new database and I have a data entry form. (I am entering check information for daily deposits). I would like to enter my operator ID one time and have it automatically entered on each new record. This would also need to work if multiple persons entering at same time. Is this possible. I'm trying to reduce key strokes.

 

[SteveA]

If you are using Workgroup Security you can place =CurrentUser() in the default value field of the OperatorID field and it will automatically populate with the current users ID.

HTH
SteveA

 

[dsmoot]

I was hoping not to use workgroup security. Is there any other way?

 

[Fizzio]

I have done this (probably the hard way) by creating a table with a single field CurrentUser then using a login screen, setting theat value to the single record using a recordset, or in your case, setting the value to a lookup value using the DLookup function. Then to set the default value for OperatorID in your table/form to this value.

HTH

 

[jwindon]

By chance are your users on an NT workgroup. I tried some code from the MS Knowledge base that grabs the NT user log in name and then I used that in my forms for the current user.