edit calculated field

[john]

I am trying to be able to input a number on a form that
is from a calculated field from a query. I changed the
properties on the form to be enabled:yes, locked:no but I
am still not able to edit that field.

please help
Thanks,
john

 

[Rick Brandt]

I am trying to be able to input a number on a form that
is from a calculated field from a query. I changed the
properties on the form to be enabled:yes, locked:no but I
am still not able to edit that field.

You cannot edit a control bound to an expression. (how could you?)

 

[John Vinson]

I am trying to be able to input a number on a form that
is from a calculated field from a query. I changed the
properties on the form to be enabled:yes, locked:no but I
am still not able to edit that field.

A calculated expression is either editable or it is correct. The
developers of Access chose (wisely IMO) to opt for having it be
correct. No, you cannot edit an expression, and you should not be able
to do so.

If the expression is simply a default, then you should have a field in
your table for the value, and set its default value in VBA code after
you have updated the fields which comprise the expression. What is the
expression?