problem when adding data, i can't view the newly added correctly

[jaz215]

when i add data it doesn't seem to go into the recordset immediately i have to close the program and reopen before i can see the newly added data. i tried refresh and requery but it doesn't seem to work

[Killer42]

when i add data it doesn't seem to go into the recordset immediately i have to close the program and reopen before i can see the newly added data. i tried refresh and requery but it doesn't seem to work

Could you give us some details about the version of VB, what sort of database, how you're accessing it, and so on?

[jaz215]

Could you give us some details about the version of VB, what sort of database, how you're accessing it, and so on?

I'm using VB6. I access data through the adodc connecting to MS Access. I just set the properties of the adodc to connect.

The way I add is:

adodc.recordset.addnew
 <asigning values to textboxes conected to the adodc>
adodc.recordset.update
adodc.recordset.refresh

It's just a basic code and it worked fine when I started but now it seems that something has gone wrong and I cannot view the added data immediately.

Thanks.

[jaz215]

got the answer in another thread sorry for this. anyway to fix the problem i just have to refresh twice dont know why this is. thanks

[Killer42]

got the answer in another thread sorry for this. anyway to fix the problem i just have to refresh twice dont know why this is. thanks

Hm. Sounds like more of a workaround than a solution. But I guess if it works, that's what really matters.

[Killer42]

Sorry people, TSDN is English-only. I've deleted your posts.

[jaz215]

Sorry people, TSDN is English-only. I've deleted your posts.

Sorry about that Killer.. will use english from now on :P