Default Value-Complicated

[Iram]

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

 

[PieterLinden via AccessMonster.com]

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.