下面代码,插入行后,鼠标有时能定位到新插入的行,有时不能定位到新插入的行,怎么样让他插入后就直接定位到当前行。
Dim sort As String = Tables("工程款申请").sort
Dim r As Row = Tables("工程款申请").Current
Tables("工程款申请").AllowMerge =False
Tables("工程款申请").sort = ""
Dim nr As Row = Tables("工程款申请").InsertNew
nr.Move(r.Index + 0)
Dim cs() As String = {"序号","项目编码","所属机构","项目名称","建设单位","合同金额","合同工期","开工日期","竣工日期"}
For Each c As String In cs
nr(c) = r(c)
Next
Tables("工程款申请").AllowMerge = True
Tables("工程款申请").Sort = "序号,项目编码,所属机构"