Check if a record with a specific ID exists

[Phantom1]

I want to check if a record with ID 1 exists.

rs.Open "SELECT * FROM tblTransaction WHERE TransactionID = 1", DBConn

There are no records with ID 1. rs.Fields.Count returns 9. How can it?