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

K

Kip

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.
 
C

Carl Rapson

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

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
 
Top