If DataEnvironment1.rsCommand1.State = adStateOpen Then DataEnvironment1.rsCommand1.Close End If 这样写肯定可以刷新的,关键是rsCommand1并不是固定的,要看你的具体的命令,但你一定要确定打完DataEnvironment1.后自动有rsCommand1之类的命令
With DataEnvironment1.rsCommand1
If .State = adStateOpen Then .Close '.Source = sql .Open End With datereport1.show一定可以
DataEnvironment1.rsCommand1.Close
End If
这样写肯定可以刷新的,关键是rsCommand1并不是固定的,要看你的具体的命令,但你一定要确定打完DataEnvironment1.后自动有rsCommand1之类的命令
If .State = adStateOpen Then .Close
'.Source = sql
.Open
End With
datereport1.show一定可以