If Nz(c) < 1 Then
MsgBox "يجب وضع عدد الأقساط أولاً", vbCritical, "Officena"
c.SetFocus
Exit Sub
Else
DoCmd.SetWarnings False
For counter = 1 To Me.c
DoCmd.RunSQL "DELETE detail.name, detail.name FROM detail WHERE (((detail.name)=[forms]![frmmain]![name]));"
DoCmd.RunSQL "INSERT INTO detail ( num, name ) SELECT nz(DMax('num','detail','name=forms!frmmain!name'))+1 AS Expr1, [forms]![frmmain]![name] AS Expr2;"
Next counter
DoCmd.SetWarnings True
Me.Refresh
End If