Update one field automatically based on whatever is entered in another field

[Abeetan]

Hello,

How can I update a field automatically based on whatever is entered in another field? See the Image attached, please

 

[Cotswold]

Make the source of the archive field = to that of the Outgoing. Or write it in on Outgoings AfterUpdate Event .
Then write the archive data permanently from your [Save] button's event.

 

[oleronesoftwares]

in VBA On the after update event of tbloutgoingpo.purchaseorder

enter the following
me.tblarchivePO.purchaseordernumber=me.tbloutgoingpo.purchaseorder

 

[bastanu]

Why do you re-post your question?

Enter data in one and have another field update automatically - Data Entry Form

Hello I have two tables that are linked with a field called the "Purchase Order Number" (one-to-one Relationship). In one table, I have certain fields that describe the purchase order number and I have another table that has more fields that describe the purchase order number. Obviously, this...

www.access-programmers.co.uk

We are all impatient seems like, but by doing this you will dilute the number of posters and their attention...
Have you tried the suggestions offered in your original post? If not, why not continue in there?

Cheers,