currentuser question

[JohnHo]

This is probably simple but this is the last feature for an db app and I am stumped (read fatigued).

I have created users with the Access security feature.

Additionally, I have a lookup table (lkupClinicianInfo) with user information (lngClinicianID, txtUserName, etc.) for various other purposes. The txtUserName string and CurrentUser string are exactly the same. For a new record I would like to insert the clinician ID (lngClinicianID) from the lkupClinician table based on the CurrentUser function. The main table (tblCallLog) has the lngClientID field.

I have created a query where I can select the lngClinicianID from lkupClinicianInfo table based on the CurrentUser.

The user logs onto the app and pokes a button to create a new record. How do I insert the lngClinicianID in the new record in tblCallLog?

thanks a lot!!

/jh

[ADezii]

@JohnHo
To retrieve the lngClinicianID from lkupClinicianInfo, based on the Return Value of CurrentUser():

DLookup("[lngClinicianID]", "lkupClinicianInfo", "[txtUserName] = '" & CurrentUser() & "'")

The Return Value would be written to the lngClientID Field of tblCallLog in some manner.

[JohnHo]

Thanks that worked fine!

[ADezii]

@JohnHo
Glad it worked out for you.