How can I manually edit a field tied to a control source?

[Guest]

I have a field on a form that I am automatically picking off 2 numbers from a
previously entered field using control source and the left commands.
However, every once in a while this field will need to be overwritten with
the correct information, but I don't know the exact expression to allow this
to happen and I am getting an error message.

 

[Carl Rapson]

I have a field on a form that I am automatically picking off 2 numbers from
a
previously entered field using control source and the left commands.
However, every once in a while this field will need to be overwritten with
the correct information, but I don't know the exact expression to allow
this
to happen and I am getting an error message.

Don't use the Control Source property. Instead, in the AfterUpdate event of
the previously entered field, "pick off" the 2 numbers and place then in the
other field.

Carl Rapson

 

[Guest]

Thx Carl.....I kind of figured I was going at it the wrong way.

Many thx

Kip