SQL Error HELP!

[werks]

Hi guy'z, when i run my program i encounter an error

missing semicolon (;) at end of SQl Statement

[CODE=vb6]CoNN.Execute "INSERT INTO tblBooks (DonorID) VALUES (" & Me.txtDonorID.T ext & ") WHERE AccessionNo=" & Me.txtAccession No.Text & ";"[/CODE]

Please help..tnx in advance


--
Kenneth
"Better Than Yesterday"

[werks]

Is Where clause not compatible with Insert Into?

[werks]

Found the error its the WHERE clause...lol


--
Kenneth
"Better Than Yesterday"