> Help!
> I've created a simple table.
[quoted text clipped - 6 lines]
> It worked the other day so I've changed something and I've now spent
> almost 3 hours trying to work it out!
I doubt that it worked the other day. Controls bound to expressions never save
their values to the table. The ONLY way that a control's value is saved to the
table is when the ControlSource is the name of a field, not an expression. The
result of expressions do not need to be saved to tables nor should they be.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com