Public Sub ChargeNoms(C1 As Control) Dim Rst As Recordset, Xp As String * 50 Screen.MousePointer = vbHourglass C1.Clear Set Rst = Db.OpenRecordset("Select * from Bourse Order By Nom asc", dbOpenSnapshot) While Not Rst.EOF LSet Xp IIf(IsNull(Rst!Nom) Or Rst!Nom "", "", Rst!Nom) C1.AddItem Xp C1.ItemData(C1.NewIndex) = Rst!Numero Rst.MoveNext Wend Rst.Close C1.ListIndex = -1 Screen.MousePointer = vbDefault End Sub
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question