Your code needs to go on the table, and be based one the event triggered when focus is changed to a particular record, or a different record. Your code should send the address field data for the selected record to the text box.
I couldn't tell you how to do this in specific code, or I'd be able to solve my own problem posted here 8^D, but that should give you an idea what you need to do.
I haven't written any code to create the table. I just used the design view and dropped things in. I'm not sure where I would even put the code. I have been searching for the click event for the record, but I havent found anything regarding that. I think pivot tables work differently in data access pages than they do in forms. Thanks for your input.