Access交流中心

北京 | 上海 | 天津 | 重庆 | 广州 | 深圳 | 珠海 | 汕头 | 佛山 | 中山 | 东莞 | 南京 | 苏州 | 无锡 | 常州 | 南通 | 扬州 | 徐州 | 杭州 | 温州 | 宁波 | 台州 | 福州 | 厦门 | 泉州 | 龙岩 | 合肥 | 芜湖 | 成都 | 遂宁 | 长沙 | 株洲 | 湘潭 | 武汉 | 南昌 | 济南 | 青岛 | 烟台 | 潍坊 | 淄博 | 济宁 | 太原 | 郑州 | 石家庄 | 保定 | 唐山 | 西安 | 大连 | 沈阳 | 长春 | 昆明 | 兰州 | 哈尔滨 | 佳木斯 | 南宁 | 桂林 | 海口 | 贵阳 | 西宁 | 乌鲁木齐 | 包头 |

如何让它自动执行两个控件的单击事件?(

小清  发表于:2008-10-31 16:57:31  
复制

我想:双击列表框的某笔记录打开一个修改窗体,

如何让它自动执行两个控件的单击事件?(一个是自动执行一个选取方块的单击事件;一个是自动执行一个按钮的单击事件)。

然后再自动关闭那个修改窗体

我把那两个单击事件写在双击事件中了,但还是不行

 

代码以下:

Private Sub BOOKING_DblClick(Cancel As Integer)
If IsNothing([Forms]![CTRORDER]![ORDERDATE]) Or [Forms]![CTRORDER]![ORDERNO] = "*" Then Exit Sub
Forms![CTRSTATUS]![BOOKING] = Forms![CTRORDER]![BOOKING]
DoCmd.OpenForm "CTRSTATUS ADD", , , , acFormEdit
Forms![CTRSTATUS ADD]![ORDERSTATUS].Enabled = True
Forms![CTRSTATUS ADD]![ORDERSTATUS].Locked = False
Forms![CTRSTATUS ADD]!CONTAINER.Enabled = False
Forms![CTRSTATUS ADD]!CONTAINER.Locked = True
Forms![CTRSTATUS ADD]!CTRTYPE.Enabled = False
Forms![CTRSTATUS ADD]!CTRTYPE.Locked = True
Forms![CTRSTATUS ADD]!SIZE20.Enabled = False
Forms![CTRSTATUS ADD]!SIZE20.Locked = True
Forms![CTRSTATUS ADD]!SIZE40.Enabled = False
Forms![CTRSTATUS ADD]!SIZE40.Locked = True
Forms![CTRSTATUS ADD]!SIZE45.Enabled = False
Forms![CTRSTATUS ADD]!SIZE45.Locked = True

'.............................................

'以下是单击那个修改窗体中其中一个控件的事件
'(Private Sub ORDERSTATUS_Click()
If Forms![CTRSTATUS ADD]![ORDERSTATUS] = True Then
Forms![CTRSTATUS ADD]!ORDEROUTNO = Forms![CTRORDER]!ORDERNO
Forms![CTRSTATUS ADD]!ORDEROUT = Forms![CTRORDER]!ORDERDATE
Forms![CTRSTATUS ADD]!POD = Forms![CTRORDER]!POD
Forms![CTRSTATUS ADD]!DEST = Forms![CTRORDER]!DEST
Forms![CTRSTATUS ADD]!GWT = Forms![CTRORDER]!GWT
Forms![CTRSTATUS ADD]!ILV = Forms![CTRORDER]!ILV
Forms![CTRSTATUS ADD]!SHIPPER = Forms![CTRORDER]!SHIPPER
Forms![CTRSTATUS ADD]!OCONSIGNEE = Forms![CTRORDER]!OCONSIGNEE
Forms![CTRSTATUS ADD]!COMMODITY = Forms![CTRORDER]!COMMODITY
Forms![CTRSTATUS ADD]![EX VESSEL] = "ORDER"
Forms![CTRSTATUS ADD]!EXSHIPPER = Forms![CTRORDER]!EXSHIPPER
Forms![CTRSTATUS ADD]!ONHAND = True
Else
Forms![CTRSTATUS ADD]!ORDEROUTNO = Null
Forms![CTRSTATUS ADD]!ORDEROUT = Null
Forms![CTRSTATUS ADD]!POD = Null
Forms![CTRSTATUS ADD]!DEST = Null
Forms![CTRSTATUS ADD]!GWT = Null
Forms![CTRSTATUS ADD]!ILV = Null
Forms![CTRSTATUS ADD]!SHIPPER = Null
Forms![CTRSTATUS ADD]!OCONSIGNEE = Null
Forms![CTRSTATUS ADD]!COMMODITY = Null
Forms![CTRSTATUS ADD]![EX VESSEL] = Null
Forms![CTRSTATUS ADD]!EXSHIPPER = Null
Forms![CTRSTATUS ADD]!ONHAND = False
End If
'.............................................

'以下是单击那个修改窗体中其中另一个控件的事件
'(Private Sub SAVE_Click()

If Forms![CTRSTATUS]!ORDERREFRESH = 1 Then
If Forms![CTRSTATUS ADD].Dirty Then
  DoCmd.RunCommand acCmdSaveRecord
  DoCmd.Close acForm, "CTRSTATUS ADD"
  'Forms![CTRSTATUS].Refresh
  'Forms![CTRORDER].Refresh
  Exit Sub
  End If
  End If
If Forms![CTRSTATUS]!ORDERREFRESH = 2 Then
If Forms![CTRSTATUS ADD].Dirty Then
  DoCmd.RunCommand acCmdSaveRecord
  DoCmd.Close acForm, "CTRSTATUS ADD"
  'Forms![CTRSTATUS].Refresh
  Forms![CTRRETURN].Refresh
  Exit Sub
  End If
  End If
If Forms![CTRSTATUS]!ORDERREFRESH = 3 Then
If Forms![CTRSTATUS ADD].Dirty Then
  DoCmd.RunCommand acCmdSaveRecord
  DoCmd.Close acForm, "CTRSTATUS ADD"
  'Forms![CTRSTATUS].Refresh
  Forms![CTRTEMPOUT].Refresh
  Exit Sub
  End If
  End If
If Forms![CTRSTATUS ADD].Dirty Then
  DoCmd.RunCommand acCmdSaveRecord
  DoCmd.Close acForm, "CTRSTATUS ADD"
  'Forms![CTRSTATUS].Refresh
  End If
Me![CTRORDER].Refresh

End Sub

 

 

Top
小清 发表于:2008-10-31 16:59:28

补充:不是同一个窗体



符鸿敏 发表于:2008-10-31 18:55:32

Private Sub BOOKING_DblClick(Cancel As Integer)
If IsNothing([Forms]![CTRORDER]![ORDERDATE]) Or [Forms]![CTRORDER]![ORDERNO] = "*" Then Exit Sub
Forms![CTRSTATUS]![BOOKING] = Forms![CTRORDER]![BOOKING]
DoCmd.OpenForm "CTRSTATUS ADD", , , , acFormEdit
Forms![CTRSTATUS ADD]![ORDERSTATUS].Enabled = True
Forms![CTRSTATUS ADD]![ORDERSTATUS].Locked = False
Forms![CTRSTATUS ADD]!CONTAINER.Enabled = False
Forms![CTRSTATUS ADD]!CONTAINER.Locked = True
Forms![CTRSTATUS ADD]!CTRTYPE.Enabled = False
Forms![CTRSTATUS ADD]!CTRTYPE.Locked = True
Forms![CTRSTATUS ADD]!SIZE20.Enabled = False
Forms![CTRSTATUS ADD]!SIZE20.Locked = True
Forms![CTRSTATUS ADD]!SIZE40.Enabled = False
Forms![CTRSTATUS ADD]!SIZE40.Locked = True
Forms![CTRSTATUS ADD]!SIZE45.Enabled = False
Forms![CTRSTATUS ADD]!SIZE45.Locked = True

 

call ORDERSTATUS_Click()
call SAVE_Click()

 

end sub




总记录:2篇  页次:1/1 9 1 :