The best I can suggest is to create a method on the form to refresh the textboxes (ie. ThisForm.RefreshAddressData) and call this from the ListBox interactivechange event or somewhere similar.

>The address text boxes have record sources set to the appropriate fields from tables.