[RESOLVED] Problems updating a record

[jalexm]

If your adodc is on form a then it has a dataset that it got from the database.
You say you are updating the database from FromB. If you are not using the datcontrol then how are you updating the data?

If you are updating using a different object then your datacontrol must obtain that data from the database and there may need to be a slight delay between the time you issue the update statement and the time you try to do a refresh.

I wrote a project a while back that received data from a remote source, wrote it to a database and displayed the data on screen in a flex grid. Each transaction would trigger a refresh after the update statement. When using Access as a backend the grid was always showing 1 record behind. In orther words the refresh was happening before the record could be retrieved from the db. The next record would trigger a refresh that would display the previous record and this happened consistantly. When using SQL server as a backend this did not happen and the records appeared on screen as soon as they were received.

So you may just be dealing with a case where you need to do a slight delay.

In fact, I solved the problem doing what you, Gibra and other friends said.
Firstly, I tried to unbind/refresh/rebind ADODC but it didn't work.
Later I removed ADODC, unbound all the controls, and did the things manually. This worked fine. No more pauses and delays.
For some reason, ADODC.Refresh can't get new data fastly enough and when event fires it gets old data.
Now it's working fine. No ADODC anymore.
Thank you all.