1 Option Explicit dim AddNewVal as boolean2 private datagris1_keypress(byval keyascii as integer) if keyascii=vbkeytab then if datagrid1.col = 0 then strBH = datagrid1.text '记住编号 set rs = cnn.execute("select * form 商品价格表 where 商品编号='" & strBH & "'") '查找编号是否存在 if not rs.eof then AddNewVal = true end if end if end if end sub3 private sub datagrid1_rowcolchange(......) if AddNewVal select case datagrid1.col case 1 datagrid1.text = rs!商品名称 sendkeys "{Tab}" case 2 datagrid1.text = rs!商品价格 AddNewVal = false end select end sub
Option Explicit
dim AddNewVal as boolean2
private datagris1_keypress(byval keyascii as integer)
if keyascii=vbkeytab then
if datagrid1.col = 0 then
strBH = datagrid1.text '记住编号
set rs = cnn.execute("select * form 商品价格表 where 商品编号='" & strBH & "'") '查找编号是否存在
if not rs.eof then
AddNewVal = true
end if
end if
end if
end sub3
private sub datagrid1_rowcolchange(......)
if AddNewVal
select case datagrid1.col
case 1
datagrid1.text = rs!商品名称
sendkeys "{Tab}"
case 2
datagrid1.text = rs!商品价格
AddNewVal = false
end select
end sub
(1) 怎样获得DataGrid控件中当前单元格的值及怎样付值给当前单元格?
(2) 在DataGrid控件中,按Tab键,光标从一列跳到另一列,会触发DataGrid控件的什么事件?希望其他知道上述问题的前辈都来帮帮忙,不胜感激!
2. private sub datagrid1_rowcolchange(......)事件