Expresion on enter

[Guest]

What is the expresion for if I enter on one field in a form it must copy the
same value to another field in the same form.
Thanks

 

[Joseph Meehan]

What is the expresion for if I enter on one field in a form it must
copy the same value to another field in the same form.
Thanks

Do you mean Cont and '

 

[Guest]

I do not know
If I enter a value in one field on a form the same value must apear in
another field on the same line.
Thanks

 

[Sue]

in the on lost focus of the textbox for FieldA put this code

FieldB = FieldA

For FieldB set Tab Stop to No so field is skipped

 

[Joseph Meehan]

I do not know
If I enter a value in one field on a form the same value must apear in
another field on the same line.
Thanks

If you want to copy the information you entered on the prior record on a
form, you can press and hold the control key and while holding it press and
release the ' key the data from the prior record will be copied to that
field.

 

[Joseph Meehan]

in the on lost focus of the textbox for FieldA put this code

FieldB = FieldA

For FieldB set Tab Stop to No so field is skipped

Which will work if you want to copy from one field to another on the
same form and same record.

If you find yours self doing this a lot, I would suggest taking a look
at your table design for problems with normalization.

 

[Guest]

Hi

=[Cartons].[Value]=[Cartons Remaining].[Value]

I have tried this in the after update but nothing happens.
I type number of cartons into texbox "Cartons" after update it must write
the same value in textbox "cartons remaining" the values are stored in
deferent fields.
Thanks

 

[Joseph Meehan]

I do not know
If I enter a value in one field on a form the same value must apear in
another field on the same line.
Thanks

Why would you want it to "appear" in another field on the same line?

Do you want this to happen only on a form or do you want to save it to a
record? Why would you want to save the same value to two different fields
in the same record?

 

[Joseph Meehan]

Hi

=[Cartons].[Value]=[Cartons Remaining].[Value]

I am not sure what you are trying to do here. where is the above? What
are each of the references (are they fields in a table, or an unbound object
on the form ????

I have tried this in the after update but nothing happens.
I type number of cartons into texbox "Cartons" after update it must
write the same value in textbox "cartons remaining" the values are
stored in deferent fields.
Thanks