1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
Dim rst As Recordset
DoCmd.RunCommand acCmdRecordsGoToNew
courssql = "SELECT Id FROM Table1 "
Set rst = CurrentDb.OpenRecordset(courssql)
Dim controle(0 To 100) As Control
rst.MoveLast
nbr = rst.RecordCount
rst.MoveFirst
For i = 0 To nbr
controle(i) = CreateControl("F_Ajout_Formation_Stagiaire", acTextBox)
controle(i).Name = i
' --Le positionner sur le formulaire
controle(i).Left = 100
' --Définir sa largeur
controle(i).Width = 150
rst.MoveNext
Next
DoCmd.OpenForm "F_Ajout_Formation_Stagiaire" |