-
DataGrid Question
:confused: :confused: :confused: :confused:
Is there a way to update the datagrid that is bound to a dataenvironment table after that table has had a batch update done to it.
I've done a rs.ReQuery and a DataGrid1.ReFresh but it doesn't refresh or display the new records after the batch update, I can get the new record count but that is it. Any help would be appreciated.
-
rs.requery works when there is no dataenvironment.
try a manual refresh:
If DataEnvironment1.rsCommand1.State = adStateOpen Then DataEnvironment1.rsCommand1.Close
'reopen the command
DataEnvironment1.Command1
'assumes datagrid's datamember is already set.
Set DataGrid1.DataSource = DataEnvironment1
-
Thanks I was just started to doing that. At least someone else was thinking like me
:)