Replicating data from one field in another field in the same record.

[moneil]

I'm building a database to catalog my book library. There will be a field named BOOK TITLE and another field named TITLE SORT. When I manually enter a new book I'll type the book's title in the BOOK TITLE filed and I want that same data to automatically be replicated in the TITLE SORT field. This way I can remove the leading letters "A" and "THE" from a book's title in the TITLE SORT field without having to retype the title or cut and paste it. This second title field will be useful for certain search / sort functions. Any help with setting this up will be greatly appreciated. Thank you.

[pbaldy]

In a form, in the after update event of the first control:

Me.TitleSort = Me.BookTitle

using the names of your controls.