UPDATE Query
 

Hi All,

I have userform in excel to search & get data from Access database.

I need to update some values from excel to access.

Right now i am using this code

txt1 = trim(userform1.textbox1.value)
txt2 = Trim(userform1.textbox2.value) ( This is Auto generated number
in Access table )

sSQL = "UPDATE table1 SET table1.[account number] = " & txt1
sSQL = sSQL & " WHERE ID= " & txt2

Similarly I have lot of Textbox and combo box

I don't want to create
if textbox1.value < "" then perform this operation
elseif do something
elseif do more....
end if

Please help in providing single sql statement which solve all the
queries.

Thanks in advance.