Hi all,
I am using VB6 with ado data control and ado code and MS Access as the database.
I used ado control to hold selected records such as specific journal number.
I used ado code to insert and delete records off ado control data.
My objective here is to select specific journal group, and calculated their total amount.
After issuing insert, I noticed the database was updated and the new record was inserted. But the display in my form does not change. But the changes can be shown only after closing the form and running it again.(without issuing insert)
The code works fine and displays the values properly if I step through it; that is, executing the code line by line using the debugger.
I am thinking that maybe the execution of the code is too fast for before MS Access can update the table? (Just a guess.)
Any one of you has had an encounter of this situation?
Any help is highly appreciated. Thanks in advance.
I am using VB6 with ado data control and ado code and MS Access as the database.
I used ado control to hold selected records such as specific journal number.
I used ado code to insert and delete records off ado control data.
My objective here is to select specific journal group, and calculated their total amount.
After issuing insert, I noticed the database was updated and the new record was inserted. But the display in my form does not change. But the changes can be shown only after closing the form and running it again.(without issuing insert)
The code works fine and displays the values properly if I step through it; that is, executing the code line by line using the debugger.
I am thinking that maybe the execution of the code is too fast for before MS Access can update the table? (Just a guess.)
Any one of you has had an encounter of this situation?
Any help is highly appreciated. Thanks in advance.