Set form1.dgAsset.DataSource = Nothing
Set rs = New ADODB.Recordset
With rs
.CursorType = adOpenDynamic
.CursorLocation = adUseClient
.LockType = adLockPessimistic
.Source = "SELECT * FROM tblasset"
Set .ActiveConnection = cnnCMMS
.Open
End With
Set form1.dgAsset.DataSource = rs
应该可以的