[2005] Details View unable to Edit a record

I have a details view connected to access database.

The user is suppose to select a number from a drop down list and based on the value of it the details view should change.


All that is done successfully, the problem is that , when i click on the (Edit) command , the details view displays all the records in the database instead of that particular selected record.



Does anyone have any idea why this is happening ?

Not unless you show us some code so that we know what you're doing.