Thanks for the code snippet, but I used a slight variation of the code you sent me earlier and it worked this time.

Code below.
db1.Execute ("select sales.* into saltemp from sales where sales.sale_no='" & txtsaleno & "'")

Thanks for the assistance!