Multiple-step

Hello all. I'm editing a record using a Drop List from a Table using the Lookup Wizard.
I get this error:
<<< Record was NOT edited >>>

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
I've used this technique in another project with no ill effects. I removed the Drop List and the update (i.e. Edit) works fine.
Here is some more intel

1. Drop List has 6 items,
   
2. On the Edit Property sheet, I set the field to Required (also removed this requirement).
   
3. Apply to Edit - Yes (and removed this requirement as well).
   
4. I removed the Table Lookup and added the values in the "List of Values", same thing
   If I revert to "Text Field" as data input type (edit as well), I can actually add data with no problem.
   I checked my other project and set this up exactly the same (well the List Choices are different).
   What am I missing or doing wrong?
   Hopefully someone can help.
   Cheers.