أهلا بك أخي الكريم
أرجو أن أكون فهمت بشكل صحيح
تقصد ان الكود يصير بهذا الشكل؟
If Me.dd = -1 Then
Dim t
t = MsgBox("?? ??E ?E??I ?? ?UEE? ??? ?C?E C????C? ?? C??CE??E?", vbYesNo, "??? C????C? ?? C??CE??E")
If t = vbYes Then
DoCmd.SetWarnings False
DoCmd.OpenQuery "C?E??C? ??? ?CE??E"
Me.dd = 0
DoCmd.SetWarnings True
ElseIf t = vbNo Then
MsgBox "E? C?E?C?? ?? C????"
End If
Else
Dim r
r = MsgBox("?? ??E ?E??I ?? ?UEE? ??C?E C???? ???CE??E?", vbYesNo, "??U C????")
If r = vbYes Then
DoCmd.SetWarnings False
DoCmd.OpenQuery "Q1"
DoCmd.OpenQuery "Q2"
Me.dd = 1
DoCmd.SetWarnings True
ElseIf r = vbNo Then
MsgBox "E? C?E?C?? ?? C???U"
DoCmd.CancelEvent
End If