Hi,
I am using a Multi Column Combo box on a web form to allow users to selected multiple items (from one Recordset). The user can edit this list at any time.
When the user goes to the edit screen I get an error stating "Rowset position cannot be restarted."
After some investigation I discovered that it seems to generate this error as the Recordset used for populating the list is dependant on a variable (i.e. WHERE ID = Session("variable")) - if i remove the WHERE part of the SQL of the Recordset the page works okay - the only problem is the list is now hundreds of records long and includes information this customer should not see - how can I get around this problem? |
|
|