Edit a calculated field ????

[Dan]

Hi,

Is there any way to edit a calculated filed in a form?!!!

eg: iif([field a]= "other", "make the calculated field to
data enter"

I know does not sound right...

Thanks

 

[Rick B]

not sure what you are trying to do here.

if fieldA=other, then what? Have the user make an entry in a field?

You could use code to say that if FieldA = other, then don't let the user
exit the form until a particular field is entered.

Is that what you want?

Rick B


Hi,

Is there any way to edit a calculated filed in a form?!!!

eg: iif([field a]= "other", "make the calculated field to
data enter"

I know does not sound right...

Thanks

 

[TC]

The Current event of the form could examine the data in the current record,
then change the ControlSource of the relevant textbox to:

- an expression, if you want that textbox to display a calculated value, or

- the name of a field for that form, if you want that textbox to allow
data-entry into that field.

Is that what you want?

HTH,
TC

 

[fredg]

Hi,

Is there any way to edit a calculated filed in a form?!!!

eg: iif([field a]= "other", "make the calculated field to
data enter"

I know does not sound right...

Thanks

Dan,
I would strongly urge you to re-think and re-write this question.
If it doesn't 'sound right' to you, it is certainly confusing to the
rest of us.
Re-post in this same thread.
Is it [FieldA] you wish to change, or a different field, if [FieldA] =
"other"?
What do you want to happen if [FieldA] is NOT= "other"?
Give an example or two of what you would like to happen.

 

[Mike Painter]

Hi,

Is there any way to edit a calculated filed in a form?!!!

No.

eg: iif([field a]= "other", "make the calculated field to
data enter"

The only way to do that is to make the default value for a field equal to
the calculation you wish to use.
If the results are wrong you can then change the value.

This is rarely a good idea and should be done only if you know why it should
not be done...