How do I get a text field to automatically copy itself elsewhere?

[Guest]

I don't want to enter the same data repeatedly (such as name, street address,
etc).

 

[Rick Brandt]

I don't want to enter the same data repeatedly (such as name, street
address, etc).

The requirement to do so normally means that your database is not designed
properly. With properly normalized tables it should be fairly rare to enter the
same information repeatedly.

 

[John Vinson]

I don't want to enter the same data repeatedly (such as name, street address,
etc).

Then store it - ONCE - in a Table, and use Queries to link that table
to the different information stored in other tables. That's how
relational databases work. You do *not* want to or need to *copy* the
information into other tables; each table contains different kinds of
information, and you use Queries to link the information together.

If you're assuming that you must have all the information in one Table
in order to view it or to print it, revise that assumption; Forms,
Reports, and exports can be (and usually are) based on Queries.

If you'ld post some more details of your data structure, someone
should be able to help. Or you might want to check out the resources
at

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

especially the Database Design 101 links.

John W. Vinson[MVP]

 

[Guest]

You use an event procedure in the "After Update" event. Click on your field,
click on properties, clidk on the event tab, and click on "AferUpdate" then
click the build button. You can then tell it to copy your data to another
field. I forgot the exact language I used but I will find it and get back to
you with it in case you can't figure it out.