Refreshing or Updating a dataset ?

Hi guys and girls.

I would like to know if a dataset is updated when you tell it to do it, or it's doing like when he want.

Cause, I have a form where the parent dataset is. And in the functions, there is a dataset that is refered to this one.

then in the function you do an update etc...

but at one point, I am trying to access it and I can't. and when I check it out, it's look like the last entry I added isn't in it. But at the same time the program is running, in the database the new row have been added and I can see it.

Also if I close the program and restart it, the modification of the dataset have been corrected. Soo that's mean I would need to force the update or kinda do a refresh of the parent database ?

is that what I need to do ? and if yes, then how does I do it ?

As far as im aware the record set will only contain information when you tell it to, and similarly will only update if you tell it to.

Whilst vb.net is smart, its not psychic mate.

ok but here is my problem

I have a DataSet that is kinda principal. In all the function the guy before created new dataSet that were in reference to the principal one.

So one of the child supposely when one of the child in a function is updated, then that's mean the principale should be update too. And when you create a new one that is refered to this one it should have the new rows inside.

But when I try to see access the last row that are added, it's telling me the program is trying to access something that doesn't exist. Like if it haven't been update. But it's have been cause if I do a query in SQL command, I can see that it is inside my DB. also if I close the program et reopen it, the new rows are inside.

It's kinda buzzy. Even my boss is gettin crazy I believe cause all the program is big and all in ping-pong for a little mini-program.

I am having a similar problem...I was just wondering if you found a solution. Does the dataset need to somehow itself be updated on the parent form? I would really appreciate any insight.