SQL Question

[Dillinger4]

Hi all! I know this is probably too easy for
some of you but im not too sure how to do this.
If i open a recordset with a SQL statement does access
create a temporary table to hold the information?
And how do i get the information that i an extracting
to a picture box on a form?

Private Sub cmdDriverQuery_Click()
Dim strSQL As String
strSQL = "SELECT * FROM [Driver Information]"
Set rs = db.OpenRecordset(strSQL)
frmDriverQuery.Show
frmDriverQuery.picDriverQuery.Print ???
End Sub

Thanks all.

[sanon]

The query will return a result and it will be held by a recordset variable. You can extract a data by using rs!field_name.