Hi there, I continue to get the following error when trying to update a form.

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/html/advertiser-basic-details.asp, line 144

Some of my code below.

SELECT tblSuppliers.idSupplier, tblLocation.Location, tblCountry.Country
FROM tblCountry INNER JOIN (tblLocation INNER JOIN tblSuppliers ON tblLocation.idLocation = tblSuppliers.iLocation) ON tblCountry.idCountry = tblSuppliers.iCountry

    ' execute the update
    Set MM_editCmd = Server.CreateObject("ADODB.Command")
    MM_editCmd.ActiveConnection = MM_editConnection
    MM_editCmd.CommandText = MM_editQuery
    MM_editCmd.Execute <------------ Line 144
    MM_editCmd.ActiveConnection.Close
    If (MM_editRedirectUrl <> "") Then
      Response.Redirect(MM_editRedirectUrl)
    End If
  End If
End If
%>

I just noticed that if I enter a number rather than text, it works....

:(

Anyway around this by changing a little code?

It is unclear from your code what you mean by "enter a number". Your Select statement as supplied does not use dynamically supplide values... it isn't an update statement, but merely a select statement. Executing that statement will should return a recordset, not update the database. Is it possible this is not part of the code you are trying to fix?

Woody Z http://www.learntoprogramnow.com

Did you ever get an answer cuz im having the same problem some what

No I dont think we ended up using that code, didnt get any result. Are you getting the result because of an INNER JOIN, or is it something else?

Mally

http://p2p.wrox.com/topic.asp?TOPIC_...Terms=80040e10 check out this forum