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
| Sub modif_form_bonzai()
Dim ff As New Form
Dim ctrl As New Control 'objet generique
Dim nom As String
Dim c As ComboBox 'pour parametrer la liste deroulante
Dim mareq As String
Dim monrs As New Recordset
DoCmd.OpenForm "formbonzai", acDesign
mareq = "select code_origine, libelle_origine from guillaume_origine, guillaume_bonzai where guillaume_origine.code_origine=guillaume_bonzai.code_origine_bonzai"
Set ff = Forms("formbonzai")
Set ctrl = CreateControl(ff.Name, acLabel, acDetail, , "type d'arrosage", 100, 6000, 2500, 400)
Set ctrl = CreateControl(ff.Name, acComboBox, acDetail, , "code_origine", 3000, 6000, 2500, 400)
Set c = ctrl
c.ColumnCount = 2
c.ControlSource = "code_origine"
c.Name = "code_origine"
c.RowSource = mareq
DoCmd.Close asform, ff.Name, acSavePrompt
DoCmd.OpenForm ("formbonzai")
End Sub |
Partager