hello,
I am now trying to allow users to change their passwords
so i used the following update command....

Update SysUser
Set Password = '" & m_NewPwd & "'
Where UserNo = " & m_TheUser & "

when i run it i get a syntax error

what is confusing me is that in another part of my program i am using an update command and it is written exactly the same,,

Update Complaint
Set Complaint = '" & m_TheComplaint & "'
Where ComplaintNo = " & m_CNo & "

I have no idea why one command will work fine but the other does not???

Anyone have any ideas?

Thanks,

Iain