Passing Parameters

[stacekz]

I am receiving the error message on my update form: "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. "

I can tell the parameter is getting passed because in the address bar it shows it getting passed: "http://###.###.#.#/AAAA/Update_Parts.asp?AutoNum=144"

I double checked the form passing the parameter, here is the link to passing the parameter:

<A HREF="Update_Parts.asp?<%= Server.HTMLEncode(MM_keepURL) & MM_joinChar(MM_keepURL) & "AutoNum=" & Parts.Fields.Item("AutoNum").Value %>">M</A>

I believe it has something to do with my Select Statement for Update_Parts.asp, here it is:


SELECT Parts.*, Departments.*, Subtitles.*
FROM (Departments INNER JOIN Parts ON Departments.ID = Parts.Department) INNER JOIN Subtitles ON (Subtitles.StID = Parts.Sbtitle) AND (Departments.ID = Subtitles.Departs)
WHERE AutoNum = MMColParam


Any help would be appreciated here.

ASP VB w/ Microsoft Access Database

[lmf232s]

try to add a

Response.write SQL
Response.end

Right after the sql statement, this will then print the sql statement on the screen and you can see what is trying to execute. This may uncover your problem.

You may find that your not initiating a variable or something like that.

Also if you not using

<%option explicit%>

at the top of your page, add it. It may help to uncover an error.