how to update another table at the same command button?

[hanarina21]

i have an error occured in my project when i try to run it..
when i placed the code

"Set RS = Nothing
sql6 = "Update alatan set STATUS_ALATAN = 'Belum di pinjam' where NO_INVENTORI= '" & Text1.Text & "' "
con.Execute (sql6)
Set RS = Nothing
"

the error says that
"microsoft [odbc microsoft access driver ] too few parameters.expected 1.
how can i fix the error?

[Jordan]

You need an Update before you can set:

UPDATE table SET RS=........

[hanarina21]

Originally Posted by Jordan

You need an Update before you can set:

UPDATE table SET RS=........

thanks 4 the code that you've post.
but i'm not really clear with the code.can you give an example of code about the update command.
thanks..
i need reply from you as soon as possible.

[hanarina21]

thanks 4 the code that you've post.
but i'm not really clear with the code.can you give an example of code about the update command.
thanks..
i need reply from you as soon as possible.

[Jordan]

Try this:


"UPDATE tableNameHere Set RS = Nothing
sql6 = "Update alatan set STATUS_ALATAN = 'Belum di pinjam' where NO_INVENTORI= '" & Text1.Text & "' "
con.Execute (sql6)
Set RS = Nothing
"