Hi,
I have a code in form, when i click command button, it should update 2 fields in the table. But it is not updating. I think there is something wrong in code. If it is only one field update, it works fine. It is not updating if there are 2 fields to update.
CurrentDb.Execute "UPDATE APPLICATION SET APPLICATION.STATUSID = 1 AND APPLICATION.STATUSREMARKSID =2" _
& " WHERE (((APPLICATION.APPLICATIONID)=" & Me.APPLICATIONID & "));", dbFailOnError
Please help me to sort out this
wasim
I have a code in form, when i click command button, it should update 2 fields in the table. But it is not updating. I think there is something wrong in code. If it is only one field update, it works fine. It is not updating if there are 2 fields to update.
CurrentDb.Execute "UPDATE APPLICATION SET APPLICATION.STATUSID = 1 AND APPLICATION.STATUSREMARKSID =2" _
& " WHERE (((APPLICATION.APPLICATIONID)=" & Me.APPLICATIONID & "));", dbFailOnError
Please help me to sort out this
wasim