No value given for one or more required parameters

[Watermelon]

Hi,

I'm getting this error below after I try to open
a record set:

"No value given for one or more required parameters."

Does anyone know what could be causing this? Here is the code:

rstCustomers.Open "Select * From Customers where Customers.LastName Like " & "'%" & txtLastName & "%'" & "", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

Thanks for any help,

Watermelon

 

[BlackKnight]

Hi,

Is the code all on 1 physical line? I copied/pasted your code and it worked without modification.

Have a good one!
BK

 

[Watermelon]

Hi,

Thanks for the response. You're absolutely right, there was nothing wrong with the code itself per se. The problem was, embarressingly enough, that I was referring to the field as LastName instead of LName. I guess it was a case of the error message throwing me off the trail. It's strange that I didn't receive an error message about the field not being found. Oh, well.

Thanks for checking this out for me.

Watermelon