Roselene,

The error that you get, definetly shows that the wrong data type is passed to the query. If you are sure that the counter field is a numeric field in the Database then maybe the following might work...

Code:
Set Pesq = DB.OpenRecordset("SELECT Destination from TBLTrips where Counter = " & CLng(TxtContador))
I tested both examples and it works. Let me know what happens.