الشكر كل الشكر للاستاذ او عارف علي ما بذله من وقت وتعب هذا المطلوب بالضبط بس لو سمح الوقت شرح الكود وشكرا لك ثانية
Option Compare Database
Private Sub أمر30_Click()
Dim DB As DAO.Database
Dim rst As Recordset
Set DB = CurrentDb
Dim OldClass As String
Dim NewClass As String
Set rst = DB.OpenRecordset("select * from tbl_studen where keed='منقول' And Yes_No=true ORDER BY id_stu")
rst.MoveLast
rst.MoveFirst
Do Until rst.EOF
OldClass = rst!saf
Select Case OldClass
Case "الأول"
NewClass = "الثاني"
Case "الثاني"
NewClass = "الثالث"
Case "الثالث"
NewClass = "الرابع"
Case "الرابع"
NewClass = "الخامس"
Case "الخامس"
NewClass = "السادس"
Case "السادس"
NewClass = "السابع"
End Select
rst.Edit
rst!saf = NewClass
rst.Update
rst.MoveNext
Loop
Set DB = Nothing
Set rst = Nothing
Form.Requery
End Sub
Private Sub أمر31_Click()
Dim DB As DAO.Database
Dim rst As Recordset
Set DB = CurrentDb
Set rst = DB.OpenRecordset("select * from tbl_studen where saf='" & cbo_saf & "'")
rst.MoveFirst
Do Until rst.EOF
rst.Edit
rst!yes_no = True
rst.Update
rst.MoveNext
Loop
Set DB = Nothing
Set rst = Nothing
Form.Requery