ADO Data List Problem

[jfarrell]

If anyone can help me with this I would appreciate it.
I have a bound DataList (DataList1) Control bound to Adodc1.
Data Source Adodc1
Bound Column Empid
Data Field Empid
List Field LName
Row Source Adodc1
My code is as follows
Private Sub DataList1_MouseUp(....
Adodc1.Recordset.BookMark = DataList1.SelectedItem
end sub

The problem is when I click on a name in the Data list
I get the error "The change you requested to the table were
not successful because they would create duplicate values in the index, primarykey, or relationship. Change the data in the field that contain duplicate data, remove the index or redefine the index to permit duplicate entries.

Empid is the primary key in an Access table. There are no
duplicates in the Empid field but there are dups in the
Lname field.
Any suggestions.
Thanks
John

 

[wekkew]

Dear John

are you using the list box JUST to select a record? If you are then you only need to set the listfield and rowsource propreties.

Because you have set BoundColumn/RowSource then the selected record is saved into the current record within the recordset, and it's probably that saving that's causing the error. This is a common problem wiht list boxes as you can use them just to list information from the db or to actually edit the db.

Also - you are much better off using the data environment (click project | Data Environment) than the data control to connect to a db - much more options.

Kate

 

[thankyou]

Thankyou Kate for the solution. I am very grateful to you.
John