I have used VB to connect to access many times. But now I need to connect to SQL server. I create a recordset object on my form and the list for the connect field gives me choices of Access, Excel, text and so forth but no SQL server.

I tried to use the dataform wizzard which was what I really wanted to do and all I could do is connect with ODBC.

Thanks
Brandon