Im in a bit of a muddle and hope someone can help.
I have a set of pages..
Page 1 displays a list of records in my accces database,
there is a repeat region on the list with a link to go to an update
page passing the records ID as an url parimeter.
Page 2: update page
The update page opens up and has an update recordset on it so
I can change a value and update the record..
This works and is set to go back to Page 1 on completion.
But on comming back to page 1 im still carrying the url
parimeter of the ID as i see it in the address bar so now im back
on Page 1 when I click my link to go to the page 2 to update the
next record I get an error saying
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error
(comma) in query expression 'id = 6, 5'.
Is there any way I can clear the url parimeter once I reach
page 2? so when i go back to the first page i can start again?