Access's Recordset GUI bug (1 Viewer)

[Chatbox]

I have a recordset (Disconnected) that's opened for UpdateBatch usage.
certain values of the recordset are change via VBA code (say, Field1 increment by 1 for all rows/records).
The recordset is also the .recordset property of a subform (in datasheet view).

After changing the values of Field1, by using fields("Field1").value = ...., the new (not yet updated to server) values do not reflect in the GUI (subform), but the recordset values are correct (msg rst.fields("field1").value). The new data do not show in GUI untill I do a .updatebatch.

Why is that?

On the other hand, if the recordset is not open in a BatchOptimistic mode, i.e. just normal LockOptimistic, the updated values are reflected in the GUI (subform), but then that means I don't get a chance to "preview" the changes before new data are submitted to the server.

So, I have an issue here; You can Update, but can't preview (batch mode). Or, you can Update AND see the result at the same time (normal update).

All I want is to be able to preview first, then decide if I want to update (batch mode).

Help?

 

[Chatbox]

Reason why I want to be able to preview batch changes to the recordset in a datasheet view is because the datasheet consists of some data where the user will apply a batch changes (via vba code) AND also edit the changes on the datasheet directly.

So, I need the ability to batch change the values, then let user preview the batch change, then let user edit certain other records, THEN do a batch update to the server....


Really really need big help one this...

 

[Chatbox]

Anyone? Where are my usually group of Gurus?

 

[Chatbox]

Please? It's rather urgent...

 

[SforSoftware]

Did you try a refresh/recalc at the form?
Or try to re-connect the recordset to the form?

 

[Chatbox]

Did you try a refresh/recalc at the form?
Or try to re-connect the recordset to the form?

yes...did all those.