Too few parameters. Expected 1

**Welshgasman** · 12-20-2021, 03:48 AM

You are not even posting consistent code?

Code:

tmpRS = db.OpenRecordset("SELECT * FROM tbl_PP_ISD_ WHERE tbl_PP_ISD_.[FPNumber] = '" & Me.txtProjectNumber & "' ;", dbOpenDynaset)

Code:

strSQL= "select * from tbl_PPISD where tbl_PPISD.[FPNumber] = " & Me.txtProjectNumber & "'""

Table name is not even the same?

**carmenv323** · 12-20-2021, 06:14 AM

Originally Posted by Welshgasman

You are not even posting consistent code?

Code:

tmpRS = db.OpenRecordset("SELECT * FROM tbl_PP_ISD_ WHERE tbl_PP_ISD_.[FPNumber] = '" & Me.txtProjectNumber & "' ;", dbOpenDynaset)

Code:

strSQL= "select * from tbl_PPISD where tbl_PPISD.[FPNumber] = " & Me.txtProjectNumber & "'""

Table name is not even the same?

I realized it was a dumb name. I copied it from another table and made it local, added the underscore and bad idea so I changed it.

**Welshgasman** · 12-20-2021, 06:26 AM

So if you do as we have asked, Access should prompt you for what Access thinks is a parameter?