How do I allow user to edit value in continouos form - aaaarggghhh!!

[Mojo]

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

 

[Arvin Meyer MVP]

AllowEditing only blocks changes made through the user interface, not
through code. You should be able to use your expressions in the underlying
query that is the recordsource of your subform.

 

[Mojo]

????

AllowEditing only blocks changes made through the user interface, not
through code. You should be able to use your expressions in the underlying
query that is the recordsource of your subform.

 

[Arvin Meyer MVP]

You'll need to supply a better question than that. Do you not have a query
as the recordsource of the subform? If not do your calculations in a query
column.