edit calculated field

  • Thread starter Thread starter john
  • Start date Start date
J

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
 
john said:
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.
Click to expand...

You cannot edit a control bound to an expression. (how could you?)
 
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.
Click to expand...

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?
 
Back
Top