Update Table from another Table using Visual Basic Code

[Serenityquinn15]

Hi!

I have two Table names:

tblupdate
tblDetails


What i want to do is to update the table tblupdate from tblDetails using the button in Visual basic Interface.

Here my code:

Str = " Update tblupdate " & _
" Set tblupdate.Text1 = (Select Text1 From tblDetails where tblDetails.Text 1 = '" & Text1.Text & "') " & _
" Where tblupdate.EEID = tblDetails.EEID "
con.Execute Str

but the error says : "No value given for one or more required parameters."

Pls. help me. tnx.