Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Move one recordset with another recordset
Message
 
À
04/06/2003 00:51:07
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00795022
Message ID:
00796044
Vues:
26
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform