Re: Auto-populating duplicate info in the same record.

Hi John,
it is easy to do.
Me.CopyOfAddress = Me.Address, use it in the after update event of the
text 
box called Address.
It will put the value of a text box called Address into a text box called 
CopyOfAddress.

Change the obvious to suit the names of your text boxes.

If you are trying to store both copies of the address in the same table or

in 2 different tables, this is against the rules for designing databases 
(except for some situations).
This creates the problem that every time a user changes the original 
address, there needs to be code to change the address in the field which
is 
a copy of the address.
It can easily lead to inconsistent information - the address in one field
is 
different from the address in the other table for the same person.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

<John Dakin> wrote in message news:200812303113andersonssix@[EMAIL PROTECTED]
>I enter one time events in each record in a form view. Information in one

>field might need to be duplicated in another. For example a name or
address 
>may have to be repeated in the same record. How can I get a one time
entry 
>in one field to auto-populate into another field in the same record?