You can do 2 things:
1. loop through the ItemData values until you find the value you saved
2. Use the JOIN clause into your SQL quwry to retreive the SN alue at the same time you retreived all other value and set the Text property of the combo to this value (notice that you won't be able to set this property if the combo's style is set to dropdownlist).
>It is a standard ComboBox with the following code to populate the box:
>
>Do While Not adoSiteRS.EOF
> cmbDiveSite.AddItem RTrim(adoSiteRS("SN"))
> cmbDiveSite.ItemData(cmbDiveSite.NewIndex) = adoSiteRS("RN").Value
> adoSiteRS.MoveNext
>Loop
>
>After it is populated, I need it to move to the record # stored in the field "SN" of the recordest adoLogRS (The actual data stored in the adoLogRS("SN") is the record number adoSiteRS("RN")
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com