. , . : , (FromSelect).
.
?
Private Sub FromSelect_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "FromSelect"
DoCmd.SetWarnings False
Me.S1.Requery
Me.S2.Requery
End Sub.
.
, , -, , - - . , . .
.
- .
. .
( ).
SQL DELETE * FROM where in (select from )
DelT.
. .
Private Sub DelTov_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "DelT"
DoCmd.SetWarnings False
Me.S1.Requery
Me.S2.Requery
End Sub
, ? . . . . Delete * From ( ClearOtbo r).
Private Sub DelTov_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "DelT"
DoCmd.OpenQuery "ClearOtbor"
DoCmd.SetWarnings False
Me.S1.Requery
Me.S2.Requery
End Sub
.
. , . ClearOtbor .
. 3
Private Sub Form_Close()
DoCmd.SetWarnings False
DoCmd.OpenQuery " ClearOtbor "
DoCmd.SetWarnings False
End Sub