I have various database tables, one that holds the options within a drop down list - each selection has a value assigned to it. One of the options is "other" which has the value -1 assigned to it. The other table takes the data from a form that the user has completed and stores it in a different database table. However instead of saving the data entered when the user selects "other" it records -1 instead. Any ideas how i can fix this?

What do you want to save instead of -1?

However instead of saving the data entered when the user selects "other" it records -1 instead

Which data are you referring to? If the user selects "other", is the user typing in the information into a text box? Maybe your INSERT INTO statement is not using the text box data.

are you using the SelectedValue property or the SelectedItem.Text property?