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 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
Private Sub suivant_Click()
Dim stDocName As String
Dim stLinkCriteria As String
Dim oRst As DAO.Recordset
Dim oDb As DAO.Database
Dim frm As Form
Dim ctlLabel As Control
Set frm = Form_modifier_flt
Set oDb = CurrentDb
Set oRst = oDb.OpenRecordset("tampon", dbOpenTable)
oRst.AddNew
oDb.Execute "DELETE * FROM tampon"
oRst.Fields("id").Value = Me.Liste0.Value
oRst.Update
oRst.Close
DoCmd.OpenForm "modifier_flt", acDesign
Set oRst = oDb.OpenRecordset("SELECT * FROM TRAVAIL WHERE id_flt='fdh_ouf'")
While Not oRst.EOF
Set ctlLabel = CreateControl(frm.Name, acLabel, , , "TEST", 15400, 200)
Wend
DoCmd.Close
oRst.Close
oDb.Close
DoCmd.Close
stDocName = "modifier_flt"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub |
Partager