Please help with SQL in VBA code

[JARE]

I am trying to create a recordset that will take PkId
And find the line in ORDER_PROCESSING table with the
Same ID. this code works fine when using TEXT fields
but when removing the quotes from PkdID I get an error
("Too few parameters, expected 1&quot PkdID is a unbound
field on a form and ID is a field in ORDER_PROCESSING query
ID is Type AutoNumber And PkdId is type General Number.



Set MyRs = CurrentDb.OpenRecordset("SELECT * FROM [ORDER_PROCESSING] WHERE [ID] = PkdId", dbOpenDynaset, dbSeeChanges)

 

[jimmythegeek]

Try this:

==========
Dim strSQL as String
strSQL = "SELECT * FROM [ORDER_PROCESSING] WHERE [ID] = " & Me![PkdId]

Set MyRs = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)

 

[JARE]

Thanks That did the trick!