Hi ChrisE,

Thank you for the vb.net code. I will change my control from Checkedlistbox to a List Box. I have a couple of questions. I have Microsoft Access 2013 and I looked at the NorthWind db. it uses an OrderID with AutoNumber as the datatype. How did you add the Order Numbers and similarly with the Customer Names (I have seen vb.net code where they use DataMember and DataValue to show item name rather than the primary key or foreign key). Could you kindly provide a vb.net code. Thanks.