hw to add multiple conditions in a single update statement?? my project goes code like this...
If release.Enabled = True And nonosc.Enabled = True Then
Dim rst12 As New Recordset
Dim sql12 As String
sql12 = "update Passport_Release_Information_N set Ename2='" & taker.Text & "' ,Any_ID1='" & takerid.Text & "' ,E_ID1 = '" & Label7.Caption & "',R_Status= '" & status.Caption & "' WHERE R_ID_N='ASDF'"
CN.Execute sql12
status.Caption = "RELEASED"
Else
If release.Enabled = True And osc.Enabled = True Then
Dim rst13 As New Recordset
Dim sql13 As String
sql13 = "update Passport_Release_Information_O set E_ID_3='" & takerid.Text & "' ,E_ID_4 = '" & Label31.Caption & "',R_Status= '" & status.Caption & "' WHERE R_ID_N='ASDF'"
CN.Execute sql13
status.Caption = "RELEASED"
End If
End If
plz help!... thankx!...
take care!