Copy/Paste within a single tabular form.

[Sreemike]

Auto-fill multiple tabs within a single form.

I have a form populated with six tabs. Each tab represents a patient test. One field contains the sample barcode ID which may be the same also for another test. Is there a way to automatically on update to copy and paste the long barcode ID from the entered field of one tab to another tab field; but still enabling the user to manually overtype this on the target field just in case the ID is different?

 

[Sreemike]

I think I got it! On field update (that is, the source field), I've added the following code:
Me.FieldNameTarget=Forms!frmName.FieldNameSource
This did paste the typed letters from the source to target as required. Furthermore, quick look at the table led me to think any alterations on the target field afterwards is retained. As a novice in VBA, I'll be very grateful if anyone who knows about VBA confirm that I am on the right track.