Darren DICK
d.dick at uws.edu.au
Tue Feb 17 22:54:12 CST 2004
Hello all I get a very long runtime error number along with the text... No value given for one or more required parameters The sql string works well as a query '########################################### Dim selSQL As String Dim rs As Object Dim con As Object selSQL = "SELECT tblStudents.StudentID, tblStudents.FormattedStudentID FROM tblStudents WHERE (((tblStudents.FormattedStudentID)=[Forms]![frmStudentSearch]![txtStudentIDSearch]));" Set rs = CreateObject("ADODB.Recordset") Set con = Application.CurrentProject.Connection rs.Open selSQL, con, 1, 3 '<=====DEBUG YELLOWS OUT THIS LINE With rs .MoveFirst .MoveLast .MoveFirst MsgBox .RecordCount End With '###########################################