Hi Mark,

Looks like I have another problem that is not related to the Deleting of the record. When I select another company's part the drop down list box goes blank until I select the second part in the same company. So I have some kind of sync problem...

Thanks

>Why are you doing a DELETE FOR? This scans the entire view and places the record pointer at EOF when finished. Since you are only updating the current record [your first parameter is ZERO], the update will fail. If you are just deleting the current record, just issue a DELETE [or DELETE NEXT 1] followed by the rest of your code.