Thanks, Lonnie. I will try your suggestion.
L y a n n e R h e e z a C. O n g
--- On Mon, 5/5/08, Lonnie Johnson <[EMAIL PROTECTED]> wrote:
From: Lonnie Johnson <[EMAIL PROTECTED]>
Subject: Re: [ms_access] display value from a dropdown list to a textbox in the
form
To: [email protected]
Date: Monday, May 5, 2008, 9:31 PM
Not sure what event you are going to use to get the value in there and it also
sounds like you have two columns on your drop down.
In the After Update of the combo box put
txtUserName = cboUser.Column( 1)
Column 1 is the ordinal position of the second column which should be the
actual text value that corresponds to the combo boxes user id.
Lyanne Rheeza Ong <[EMAIL PROTECTED] com> wrote:
Hello,
How do I display a value from the dropwdown list to a text box in the form?
If I immediately display the value of the dropdown list in the textbox, it
displays the primary key of the value selected from the dropdown list.
This is the SQL statement:
SELECT FullUserName
FROM LDAPUserList
WHERE UserID=" & Me.cboUser.Value & ";
cboUser is the dropdown list.
txtUserName is the text box.
thanks,
L y a n n e R h e e z a C. O n g
____________ _________ _________ _________ _________ _________ _
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile. yahoo.com/
;_ylt=Ahu06i62sR 8HDtDypao8Wcj9tA cJ
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev. us
------------ --------- --------- ---
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
[Non-text portions of this message have been removed]
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
