Hi All

I'm progressing with my db/app, but hit a stumble, trip - stumble, trip!

My query drops data into 4 fields in a continuous sub-form - no problem.

One of these fields needs to be editable so that the user can change the
populated date with what they need and it automatically updates 2 other
'calc' fields on the same row. In essence I have a ReturnedDate field and
the user changes this to suit, which in turn updates a 'They have rented it
for x days' field and a 'its going to cost' field.

However what the problem seems to be is that because these 2 calc fields are
leeching off my ReturnedDate field I can't edit the Returned Date field!!
I've got AllowEdits enabled on the subform and the field is not locked, but
I keep getting the ding! If I unlock one of my other fields then I can edit
away happily.

How should one set up a Access form so that info can be changed in one field
and the other fields reflect that change?? It makes no sense to stop it
from being editable.

Thanks