Hi,
I've created a form with an address line. The form currently populates the address based on the 1AddressLine1 table column (Table is call 'PhysicianList'). However, I realized the address data we have may not be accurate. So we've created an updated address column (2AddressLine1) in our table. I'd like the address line in the form to show the most recent address. Meaning, if there is something inputted in 2AddressLine1, it will pull from that field. If there is nothing in that field, I'd like the address line to pull from 1AddressLine1. How do I do this? Do I use DLookup? If so, could someone walk me through this??
Thanks!!