I use the form wizard to create a form.
I then take the following code:

Me.OleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\StockDa" & _
"ta.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";" & _
"Jet OLEDB:Registry Path="""";Jet OLEDBatabase Password="""";Jet OLEDB:Engine Type=" & _
"5;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLED" & _
"B:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create" & _
" System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Loc" & _
"ale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SF" & _
"P=False"

And replace it with :
Me.OleDbConnection1.ConnectionString = CONNSTRING

CONNSTRING being a global which holds the connection string. This works fine until I add a tablestyle to the datagrid. I then lose the entire line.

I cant find "Me.OleDbConnection1.ConnectionString = CONNSTRING" anywhere :-(

WHATS HAPPENING?? THIS IS DRIVING ME INSANE!!!!

I need to use this Global because the connection string can only be made at runtime and stored in a text field.