If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default Value-Complicated
Hello,
I have a Module that pulls the username of the person logged into the PC (if you would like to see this code, let me know). I have a table called tbl_WorkerIDs with all my staff's login Ids in a field called "LANIDs" and I have another field in the same table called "CSEIDs". Each person has a LANID and a CSEID. In a form I have a combobox field called CSEWorkerID. This combobox feeds on the above table. For the Default value of this combobox I need the CSEID to pull not the LANID which is the userid logged into the pc. On this CSEWorkerID combobox currently I have as the Default Value as =fOSUserName() which is pulling the locally logged in ID. How can I change this default value to map over to the person's CSEID? Is it possible? Your help is greatly appreciated. Iram/mcp |
#2
|
|||
|
|||
Default Value-Complicated
Iram wrote:
Hello, I have a Module that pulls the username of the person logged into the PC (if you would like to see this code, let me know). I have a table called tbl_WorkerIDs with all my staff's login Ids in a field called "LANIDs" and I have another field in the same table called "CSEIDs". Each person has a LANID and a CSEID. In a form I have a combobox field called CSEWorkerID. This combobox feeds on the above table. For the Default value of this combobox I need the CSEID to pull not the LANID which is the userid logged into the pc. On this CSEWorkerID combobox currently I have as the Default Value as =fOSUserName() which is pulling the locally logged in ID. How can I change this default value to map over to the person's CSEID? Is it possible? Your help is greatly appreciated. Iram/mcp you could use a DLookup and use the fOSUserName as the criterion. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|