Can nnot update

[BorisGomel]

Hello,



I am stack a bit here. I have a table called NANFINAL and in where I am trying to update the filed called InvoiceNumberQB with two criterias that are DateRemit and Code throught the form . I placed the form called Updateinvoice and put there three text boxes:txtInvoice,txtCode and txtDate and command button . In command button click event I typed code the below:

Dim strSQL
strSQL = "UPDATE NANFINAL " _
& "SET InvoiceNumberQB = " & Forms!UpdateInvoices.txtInvoices & "" _
& "Where Code = " & Forms!UpdateInvoices.txtCode & ""
& " Where remitDate = #" & Form!UpdateInvoices.txtDate & "#"

Access doesn't bug it as a mistake , but updating is not working .
Can somebody point me out what probelm is here.
Thank you in advance,
The Best Reagrds,
BorisGomel

[pbaldy]

Do you execute it? See if this helps:

http://www.baldyweb.com/ImmediateWindow.htm

You can't have to WHERE clauses. You separate the two conditions with And.

[pbaldy]

Oh, and you don't have line continuation characters on one of the lines.

[BorisGomel]

Thank you !!
I have rewritten code :

Dim strSQL As String
strSQL = "UPDATE NANFINAL " _
& "SET InvoiceNumberQB = & Forms!UpdateInvoices.txtInvoices & " _
& "WHERE Code = & Forms!UpdateInvoices.txtCode & " _
& "AND DateOfProcessed = #" & Forms!UpdateInvoices.txtCode & "#"
CurrentDb.Execute strSQL

Still doesn't work.
Thank you in advance.
The Best Regards.
BorisGomel

[pbaldy]

What were the results of the Debug.Print?

Your quotes were better before.

[BorisGomel]

Here. Access debugs this mistake.
I have revewed code and it seems ok.

Run-time error "3075"
Syntax error (missing operator) in query expression ' & Forms!UpdateInvoices.txtInvoices &'

Thank you.

[pbaldy]

Here's your code before (correct) and later (wrong):

& "SET InvoiceNumberQB = " & Forms!UpdateInvoices.txtInvoices & "" _
& "SET InvoiceNumberQB = & Forms!UpdateInvoices.txtInvoices & " _

See the difference? You did it again below that.

[BorisGomel]

Thank you so much !!
Now it is working prefectly.
A thousand thanks!!!
BorisGomel

[pbaldy]

Glad we got it sorted out!