I have a program where theres is a microsoft access 2003 database file and i want to pull up a query and display it in text boxes, i tried putting in the query name but it has an error, it works fine when i put a table as the data source but i need a query

code :

VB Code:
  1. Private Sub Allocated_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
  2.         'Get data from the database, put it into the DataTable object dt,
  3.         'and display the initial record's data in text boxes
  4.         Dim connStr As String = "Provider = Microsoft.Jet.OLEDB.4.0;" & _
  5.                                 "Data Source = EngineerJobs.mdb"
  6.         Dim sqlStr As String = "SELECT * FROM Engineers_on_Jobs"
  7.         Dim dataAdapter As New OleDb.OleDbDataAdapter(sqlStr, connStr)
  8.         dataAdapter.Fill(dt)
  9.         dataAdapter.Dispose()
  10.         UpdateTextBoxes()
  11.     End Sub


many thanks