Update access database next recordset not grabbing update
I am having a problem where I am updating several rows in a table. I then set the connection to nothing and close it. After that I set a recordset to the rows that I just updated and it is not grabbing the correct information. I know that the rows get updated because when I set a breakpoint in the program I cant replicate the problem. Just not updating quick enough. Is there a way to know if the updates have finished or to be sure the recordset is cleared from the last time?
Any help thanks