Option Compare Database
Dim i As Integer
Dim selH As Long
Private Sub fsub订单_Enter()
i = 2
selH = Me.fsub订单.Form.SelHeight
End Sub
Private Sub fsub订单_Exit(Cancel As Integer)
i = 2
selH = Me.fsub订单.Form.SelHeight
End Sub
Private Sub fsub明细_Enter()
i = 1
selH = Me.fsub明细.Form.SelHeight
End Sub
Private Sub fsub明细_Exit(Cancel As Integer)
i = 1
selH = Me.fsub明细.Form.SelHeight
End Sub
Private Sub 删除_Click()
'=====如何加入判断语句,当选择了子窗体"fsub明细"中某条记录,执行上半段代码=======
'=========当选择了子窗体"fsub订单"中某条记录,则执行下半段代码?=======
'在表中查找并删除当前记录
If selH = 0 Then MsgBox "你至少要选择一条记录吧": Exit Sub
If i = 1 Then
If MsgBox("您确认要删除名称为“" & Me.fsub明细.Form.设备 & "”的设备吗?", vbQuestion + vbOKCancel, "") = vbOK Then
DoCmd.SetWarnings False
DoCmd.RunSQL "delete from 表2 where 订单ID='" & selectstr & "'"
Me.fsub明细.Requery
DoCmd.SetWarnings True
Exit Sub
End If
Else
'在主窗体中查找并删除计划及其明细
If MsgBox("您确认要删除代码为“" & Me.fsub订单.Form.订单ID & "”的记录及其明细吗?", vbQuestion + vbOKCancel, "") = vbOK Then
DoCmd.SetWarnings False
DoCmd.RunSQL "delete from 表2 where 订单ID='" & Me.fsub订单.Form.订单ID & "'"
DoCmd.RunSQL "delete from 表1 where 订单ID='" & Me.fsub订单.Form.订单ID & "'"
'刷新
Me.fsub订单.Requery
Me.fsub明细.Requery
DoCmd.SetWarnings True
End If
End If
End Sub
所谓 1 , 2 就是判断焦点在哪个窗体上, selH 就是判断有没有整行选取, 否则就会提示