Hi, everybody!

I’m having problems with a SQL expression:
I have already used the “DIM” command for the variables Pesq and DB
Set Pesq = DB.OpenRecordset("SELECT Destination from TBLTrips where Counter = " & TxtContador)
This expression causes the following error message:
Run time error ‘3061’ too few parameters, expected 1.
If I try:
Set Pesq = DB.OpenRecordset("SELECT Destination from TBLTrips where Counter = " & TxtContador, dbOpenForwardOnly), I receive the same message.
And what is strange is that the both expressions works in another Private sub!

Any ideas?
Thanks in advance,
Roselene