[lightroses]

Hi to all.. I was working for now in vb6.
But I have a problem when i run the save button, the message box appeared and says"no values given in required parameters."

my code is below:

Tsql = "UPDATE Tbl_Tithes SET Label11.Caption = '" & Me.txtTithes.Text & " ' where ID LIKE '%" & txtID.Text & "%'"

Call dbConnect
TConn.Execute Tsql
TConn.Close
Set TConn = Nothing
Unload Me

I knew that the conflict code i have do is in the label11.caption. I use label11.caption because it contains the date that the user will input on the form and save in access. I dont know what to do, someone help me to fixed this problem.

[andrewsw]

UPDATE tableName SET fieldName = value

Label1.Caption is not a field in the database-table.

Me.txtTithes.Text & " ' where

This expression includes an extra quoted space which shouldn't be there.