Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Move one recordset with another recordset
Message
 
To
04/06/2003 00:51:07
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00795022
Message ID:
00796044
Views:
27
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
Previous
Reply
Map
View

Click here to load this message in the networking platform