Solved: Error "No value given for one or more required parameter"

[ktwk]

hi all, i am getting this error, "No value given for one or more required parameter" at "rst1.Open str7, CurrentProject.Connection". I don understand why, everything seems correct. Can somebody enlighten me?
thanks


cnn1.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\db1.mdb;"

Set rst1 = New ADODB.Recordset

rst1.ActiveConnection = cnn1

str7 = "SELECT ProjectID, ProjectName, ProjectSDate, ProjectEDate, ResearcherID FROM ProjectTable WHERE ProjectID = " & Me.Text0
MsgBox "" & str7
rst1.Open str7, CurrentProject.Connection
rst1.MoveLast
rst1.MoveFirst

[ktwk]

Sorry, this is the full query

str7 = "SELECT ProjectID, ProjectName, ProjectSDate, ProjectEDate, ResearcherID FROM ProjectTable WHERE ProjectID = " & Me.Text0

[matthewspatrick]

Is the ProjectID text or numeric? If text try:


str7 = "SELECT ProjectID, ProjectName, ProjectSDate, ProjectEDate, " & _
"ResearcherID FROM ProjectTable WHERE ProjectID = '" & Me.Text0 _
& "'"

[ktwk]

yup, "'"..."'" works, thanks