viewing results of query problem
I am trying to view the results of a query. Some snippets of my code:
SQL = "SELECT * FROM "& ptype &" WHERE pallet_no = 'US337+" & pal &"'
RS = DBconn.Execute(SQL)"
Now when I try to say something like RS.EOF, or RS. anything it gives me the error:
"Object doesn't support this property or method: 'EOF' "
Is there something I am missing?
Any help would be appreciated