Hi,

I found out the solution to this last night. The dbcItemNumber was a data bound combobox which was used to display the items in a record source and then change the selected record to the one selected in the combobox. but when ever i changed the cobo box it must have got confused

what i had to do was remove the data binding from the . text property but keep the data binding to the list property so that i still had a populated list of all the recordset items but it didn't get confused.

thanks for your efforts though.

cheers