too few parameters 1

[missymarie1014]

The following code is producing the error "Too few parameters. Expected 1". Can someone help me with this please? I've tried several variations of this without success. Thanks in advance for any help!

Set CurDB = CurrentDb
Set rs = CurDB.OpenRecordset("SELECT * from UnprocessedBatchQuery WHERE" & _
" ItemProduced =" & Forms!EditFinishedProductForm!Item)

 

[PHV]

Probably this ?

Set rs = CurDB.OpenRecordset("SELECT * from UnprocessedBatchQuery WHERE" & _
" ItemProduced=[!]'[/!]" & Forms!EditFinishedProductForm!Item [!]& "'"[/!])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missymarie1014]

You got it PHV. I just did that on my own and that was the problem... string fields vs numeric. Thanks for your post!