I have an Access database set up with ASP VBScript that can insert information & search records. I've added an update option to the search results page. Now, I want to have the update page pass a URL variable to another page to show that changes that were made to the record.

However, when I use the Update Record server behaivior & select the url parameter after the page to redirect to, I get the following error:

Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/edittune.asp, line 48

In looking at the code at line 48, it says:

MM_editRedirectUrl = "updateresults.asp?tuneID=" + (rsResults.Fields.Item("tuneID".Value) + ""

I'm not sure what the problem is with this code...it seems to make sense to me, but I guess I'm missing something. Any assistance would be appreciated!

Thanks!

By the way, I've tried taking out the extra + "" at the end of the line, but I still get the same error...

not sure why you have the extra try

MM_editRedirectUrl = "updateresults.asp"

I have the extra because I need to pass the variable 'tuneID' as a URL parameter...apparantly I'm getting hung up with that part of it, but surely it's possible to pass a URL parameter during an update record, right?

I was wondering if anyone had an answer to this...?