1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| If CurrentProject.AllForms!F_Destockage.IsLoaded Then
If Not IsNull(Forms!F_Destockage!CodeBarre) Then
Me.Destockage_CB_CodeBarre = Forms!F_Destockage!CodeBarre
Me.Destockage_CB_Lot = Eclatage(Me.Destockage_CB_CodeBarre, 1)
Me.Destockage_CB_Peremption = Format(Left(Eclatage([Destockage_CB_CodeBarre], 2), 2) & "/" & Mid(Eclatage([Destockage_CB_CodeBarre], 2), 3, 2) & "/" & Right(Eclatage([Destockage_CB_CodeBarre], 2), 4), "short date")
Me.Destockage_CB_Entree = Format(Left(Eclatage([Destockage_CB_CodeBarre], 3), 2) & "/" & Mid(Eclatage([Destockage_CB_CodeBarre], 3), 3, 2) & "/" & Right(Eclatage([Destockage_CB_CodeBarre], 3), 4), "short date")
Me.SF_Destockage_CB_StockTotal.Requery
Me.Destockage_CB_Compte = Me.SF_Destockage_CB_Stock.Form.Recordset.RecordCount
Me.Destockage_CB_DateDestockage.SetFocus
Else
Me.Destockage_CB_CodeBarre.SetFocus
End If
Else
Me.Destockage_CB_CodeBarre.SetFocus
End If |
Partager