Autofill Field Based on Another Field

[Enrightt]

Hello All,

I would like to have a field automatically copy the value of another after the first is entered in a form while still being adjustable, if needed.

The first field manually entered is [Invoice_State] and the 2nd is [Item_Ship_To_State]. Since 99% of the time, the Item Ship To State will be the same as the Invoice State, I would like the 2nd field to automatically copy the manually entered [Invoice_State] to save much unnecessary data input. However, I would also like [Item_Ship_To_State] to be adjustable in the the rare cases where the two fields will be different. These two fields are located in the same table.

Is there a way to do this?

Thank you very much.

[ItsMe]

You could place some code behind the form in the After Update event for the first control.
Me.[Item_Ship_To_State].Value = Me.[Invoice_State].Value

[Enrightt]

Thank you!