Hello.
I'm using Access and VB6 in my app.
In FormA there is an ADODC and some controls showing record fields.
In FormB user changes another record, saves the record and a class event is fired after that.
FormA receives that event and tries to update its screen immediately in order to show the changes made in FormB. I'm using ADODC.Refresh in event receiver to do that.
The problem is FormA can't show the changes. Curiously, if user makes another change then the first one appears in FormA.
I'm not sure, but it seems the class event is firing before the changes are really saved to database.
Please, any ideas? Thanks.