VB Code:
  1. Private Sub cmdViewSeats_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdViewSeats.Click
  2.         Dim strSeatType As String = cbxSeating.Text
  3.         Dim intGame As Integer = Val(cbxGame.Text)
  4.         Dim objRS As New ADODB.Recordset
  5.         Dim objRS2 As New ADODB.Recordset
  6.         Dim strSQL As String
  7.         Dim strSQL2 As String
  8.  
  9.  
  10.         strSQL = "SELECT Section FROM SectionPricing WHERE Description='" & cbxSeating.Text & "'"
  11.         objRS.Open(strSQL, strConnect)
  12.  
  13.         Do Until objRS.EOF
  14.             strSQL2 = "SELECT SeatNumber FROM Seats WHERE sections='" & objRS.Fields("Section").Value & "'"
  15.             objRS2.Open(strSQL2, strConnect)
  16.             objRS.MoveNext()
  17.             Debug.WriteLine(objRS2.Fields("SeatNumber").Value)
  18.         Loop
  19.     End Sub

it breaks at objRS.Open(strSQL,strConnect)
strConnect is declared globaly as

Dim strConnect As String = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=Metro Meteors.mdb"

and that is right because i use it more then once and the times before it work..... i just dont understand why its not working for this new module and its not making sense.....if it works before...why not again???? remember it breaks at that line so its not connecting.....and the SQL statement works for sure cuz i also use that before......