VBA/ADO Compile Error: Expected Function or Variable

[psycoperl]

I am getting the compile error on the rsStudentSearch.Open = "Select * From tblStudent Where stuID =" & rsReport![STUDENTID] line in the section below. It highlights the ![STUDENTID] section of the line.

I am not sure why this is throwing the error.

Thanks

Dim rsStudentSearch As ADODB.Recordset
Set rsStudentSearch = New ADODB.Recordset
rsStudentSearch.ActiveConnection = CurrentProject.Connection
rsStudentSearch.Open = "Select * From tblStudent Where stuID =" & rsReport![STUDENTID]
rsStudentSearch.CursorType = adOpenStatic
rsStudentSearch.LockType = adLockPessimistic

 

[james_lankford]

think you need the "set" in this line
set rsStudentSearch.ActiveConnection = CurrentProject.Connection

and I think you need
rsStudentSearch.CursorType = adOpenStatic
rsStudentSearch.LockType = adLockPessimistic
before the open, or else they don't do anything

</pre>