Imar,

Thanks you again for your offer of help. I looked at another forum and a gentlemen there was having the exact same problem as I am having apparently he's problem was caused by the fact he had two forms open at the same time, which of course I have as I have two forms sitting side by side, he solved this by closing one form before calling the refresh, not sure how I am going to do this as I need both forms open continually. What I might try is closing the form doing the refresh and then opening it again.

Will let you know how this goes.

Thanks Again

Louisa

Hmmm, that's interesting.

What you could also do is create a new instance of a connection on your second form. That way, the two forms aren't really bound to each other. So, each Update() method create a fresh instance of a OleDbConnection and executes its SQL statements over this connection.

I think that might fix the issue with multiple forms....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Shake Your Hip by dEUS (Track 11 from the album: Worst Case Scenario) What's This?