I Need Help!

I have a data grid that is bound to an adodc in code (since the recordsource is a join and I am not sure you can do that at design time). Here is the code that I am using:

Code:--------------------------------------------------------------------------------

Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=VIRA;Data Source=BOB"
Adodc1.RecordSource = sql
Set dgPartData.DataSource = Adodc1

--------------------------------------------------------------------------------Assume the sql value is valid (it is). I use this on form load and it works well. But whenever I try to update the display, it gets weired on me (kind of 'quivers' and then modal forms like a message box don't show up-like they are behind this form (it is a MDI child).

Maybe I am not updating it correctly. I am using a command type 'CommandUnknown' since it is a join. If I just use a dgPartData.refresh after the update, then I get an error 'Command text unknown' or something like that.

Can anyone help me out with this one?

Thanks!