Hi Scott,

You mention your steps previously:
Now the complete table has a form with a combobox for the part. I have a command button that when clicked
1. Opens the complete record form
2. Fills all the pertinent fields(one of them is this combobox.
3. Close the incomplete form and delete this record, as it is now in the complete record table.

How are you deleting the record?
Can you put up the code.

Richard mentioned the table being LOCKED. This could be the case that you still have the table open or that you are using it say to build a query for part of a form.
I'd close everything that isn't needed and then delete the record you need afterwards.

Alex