PC Review


Reply
Thread Tools Rate Thread

Default Value-Complicated

 
 
Iram
Guest
Posts: n/a
 
      6th May 2010
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Complicated Look-Up Greg Microsoft Excel Misc 1 19th Jan 2010 05:05 PM
Very complicated report to go with a very complicated query....HEL ReportTrouble Microsoft Access Reports 1 14th Apr 2009 02:02 PM
CPU FAN - How complicated can this get? maradcliff@UNLISTED.com Computer Hardware 16 9th Dec 2006 11:00 AM
Complicated: Having user overwrite default value and keep total va =?Utf-8?B?RWxsZXZl?= Microsoft Access Forms 2 17th Feb 2006 09:14 PM
Complicated =?Utf-8?B?QnJldHQ=?= Microsoft Excel Worksheet Functions 3 6th Jan 2006 03:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:46 AM.