How can I do this operation automaticly by command button:

[1aae]

How can I do this operation automatically by command button:
select column (ColumnNameA)
copy column (ColumnNameA)
select column (ColumnNameB)
paste in column (ColumnNameB)
is this possible

 

[John Spencer (MVP)]

The easy way would be to use an update query.

UPDATE YourTable
Set FieldB = FieldA

 

[1aae]

Thank you very much for your help and answer
It work correct and excellent thank you
but I want to ask you another question
If FieldA is expression in a subform.
Is there any way to copy the Value of FieldA (Expression) To FieldB (Field)
Thank you