General information
Category:
Database DAO/RDO/ODBC/ADO
>Normally, I never use Bound Controls but now I must use them in a small project. The problem I am facing now is that I have problem synchronizing 2 recordsets. I have a global ADO connection that I use as the Connection to one ADODC. I also use this connection when opening a recordset to fill a combo. When I add/update/delete data using the ADODC and I ask to repopulate the combo, my changes aren't seen before 5 seconds.
>
>Can I force the commit (much like DBIdle of DAO)?
I haven't seen this situation (since I don't use the ADODC either) but have you tried Rs.Resync or Rs.Requery?
Depending on your rs type it might be what you need.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only