Maybe it's better asked over here *RESOLVED*

Here's my code for those who haven't seen it:

VB Code:

Option Explicit
 
Private cn As ADODB.Connection
Private rs As ADODB.Recordset
 
Private Sub Form_Load()
 
Set cn = New ADODB.Connection 
 
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source= C:\mydatabase.mdb" 
 
cn.Open
 
Set rs = New ADODB.Recordset 
 
rs.Open "SELECT * FROM game WHERE hometeamid = '" & Text1.Text & "' OR awayteamid = '" & Text1.Text & "'"
 
rs.MoveFirst
Do Until rs.EOF = True 
    Combo1.AddItem rs.Fields("gameid")
    rs.MoveNext 
Loop
 
rs.MoveFirst
 
End Sub

I get an error message on my SELECT statement saying:

Code:

---

Run-time error '3709';

The connection cannot be used to perform this operation. It is either
close or invalid in this context.

---

Anyone have an idea as to why? Am I doing something wrong when I open the recordset?

Maybe this will work

dim sql as string

sql = "SELECT * FROM game WHERE hometeamid = '" & Text1.Text & "' OR awayteamid = '" & Text1.Text & "'"


rs.Open sql, Cn, adOpenKeyset, adLockReadOnly, adCmdText

You didn't associate a valid cn object for your rs. After you add you select statement add the cn object and any other params you need.

Yeah actually I should have altered my subject on the thread. I figured that out about 3 hours ago. Thanks for the reply though