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]> 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=Ahu06i62sR8HDtDypao8Wcj9tAcJ
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]
