What I need, is a form displaying a record from 'Evaluation' table, with a combo box displaying the record's original Evaluation.Lastname, with drop down list listing all possible last names from Employee.LastName ('Employee' is the lookup table for LastName). User could then change the combo box selection to a different last name (from Employee.LastName), and I'd like to write/update that new selection back to Evaluation.LastName.

I used optimistic record buffering, and upon user clicking an 'UPDATE' command button, the new LastName selection should be written back to Evaluation.LastName. So, in the UPDATE button's click event, I have:
TABLEUPDATE().

I cannot get the update to write back to the 'Evaluation' table though.

Sorry to be so confusing ... I hope this explains what my problem better????
Thank you!!!!!