1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| Private Sub Report_Open(Cancel As Integer)
Dim oRst As Recordset
Set oRst = CurrentDb.OpenRecordset("select * from tbl_param where id_param=1", dbOpenDynaset)
With oRst
.Edit
' Réinitialisation si on a atteint la valeur maximum
If .Fields("ValParamN") = 9 Then
.Fields("ValParamN") = 1
Else ' Sinon, incrémentation de la valeur
.Fields("ValParamN") = .Fields("ValParamN") + 1
End If
.Update
Me.NumEdition.Caption = .Fields("ValParamN")
.Close
End With
Set oRst = Nothing
End Sub |