Requerying an ADO Recordset based on an SQL string

[Robotron]

I have a form which displays 2 records at a time (the before record and the after record). The is also a check box which the users check when they are finished processing the record.

The form uses an ADO recordset that is based on an SQL string.

When I requery the recordset and move back and forth on the form among the records, it does not always show the most recent data, ie, when the user checks the check box and moves forward on the form and then back, the check box still shows as unchecked. I can not consistently reproduce this behavior. This leads me to believe that sometimes the requery is getting the most recent data and sometimes it is not.

If anyone can provide any solutions or insight, it would be greatly appreciated.

Phil Edwards

 

[PHV]

And what about thr ReSync method ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Robotron]

I tried the ReSync method. It's still not showing the most recent changes to the data. This is very puzzling to me.

Phil Edwards