Hi there,

Let say I wish to delete a row of record which contains StudentID, ModuleID and SessionID

My delete query is as below,

rs.Open "DELETE FROM V_ModuleReg WHERE ModuleID ='" & frmModuleReg.txtModuleID.Text & "'"

It works fine but it will delete all the students records which are having the same ModuleID since I only delete it according to ModuleID...

May I know how should I write the sql query if I wish to delete it according to ModuleID and StudentID

Thank you


Gary  

"DELETE FROM V_ModuleReg WHERE (((ModuleID) ='" & frmModuleReg.txtModuleID.Text & "') AND ((StudentID) = '" & frmModuleReg.txtStudentID.Text & "'))"

That is assuming that the StudentID data type is text  like your query indicates for the ModuleID. If it is numeric then leave out the quotes (') around the ID and coerce the textbox to a Long :-
Dim lngID As Long
lngID = CLng(frmModuleReg.txtStudentID.Text)

"DELETE FROM V_ModuleReg WHERE (((ModuleID) ='" & frmModuleReg.txtModuleID.Text & "') AND ((StudentID) = " & lngID & "))"



____________________________
multi-tasking - the ability to hang more than one app. at the same time.

Thanks friend,

This problem solved... another serious problem arise! My ADO or recordset unable to connect to the SQL Server 2000...
It displays an error message and states that "SQL Server does not exist or access denied"

I have reinstalled my SQL Server 2000 for few times but still the same... Any idea on this

Thank you...


Gary