Hi,

You need to create a SQL statement to populate your dropdown list as follows:

Select myPk, rtrim(UserCode)+ " - " + UserName as CodeName from YourTablename

Me.ComboUserGroup.DataTextField = "CodeName"
Me.ComboUserGroup.DataValueField = "MyPK"

Hope this helps.

Jacci