SA Developer .NET

First things first. Google SQL Injection and read a few articles. It's not specific to SQL Server

First guess, you have field names with a space in them. Access required that those get wrapped in []  (I think. It's been a while since i played with access). So your update becomes

rs.Open "Update tblLead set [Client Name] ='" & ...

If that doesn't work, build up the update to a string variable and print it to the debug window so that you can examine it.

Swannie1971:

The statement that I have a problem with is:
rs.Open "Update tblLead set Client Name='" & Sup_CName & "',Client Surname='" & Sup_Surname & "',Client Address='" & sAddr & "',Client Cell='" & sTele & "',App Date='" & sDate & "',Satus='" & sStatus & "',Rep='" & sRep & "'" & _
"Where Lead_ID='" & iFind & "'", cn, 3, 3

And also, is your "rs" object a recordset object? If it is just so you know you don't need to use a recordset to do an update, use your connection instead:

cn.Execute "update..."

Or something like that... haven't used VB in a while so it might be cn.Exec...

Swannie, here's a nice ADO tutorial, which covers most aspects of ADO :)

http://www.timesheetsmts.com/adotutorial.htm

Just a personal comment, IMHO, it's not good to have spaces in table field names.  It causes too much issues, especially with Access as GilaMosnter ponted out.

If you look at the meaning of this error, it could mean either that a specified field could refer to more than one table listed in the FROM clause of your SQL statement; or, that it is an ambigious field reference.  I don't know if that would perhaps nudge you in the right direction.

I hope my comments were useful :)

Swannie1971:

The statement that I have a problem with is:
rs.Open "Update tblLead set Client Name='" & Sup_CName & "',Client Surname='" & Sup_Surname & "',Client Address='" & sAddr & "',Client Cell='" & sTele & "',App Date='" & sDate & "',Satus='" & sStatus & "',Rep='" & sRep & "'" & _
"Where Lead_ID='" & iFind & "'", cn, 3, 3