<div>
Thank you LSMConsulting. &nbsp;I bound the city, state, zip fields to the &quot;address&quot; table and obtained the desired results. 
</div>


Thank you LSMConsulting.  I bound the city, state, zip fields to the "address" table and obtained the desired results.

<div>
<div class="content wysiwyg-content">
I am using the instructions on the following link to populate the address text boxes (city, state, zip) in an address subform where there may be multiple address for a person. &nbsp;The instructions work well for a single address but when I select the zip code it will populate the city, state, zip unbound text boxes for all of the address records for that person. &nbsp;Is the a way to isolate writing to the text boxes for the particular address record?<br />
<br />
<a href="http://support.microsoft.com/kb/322901" rel="ugc nofollow">http://support.microsoft.com/kb/322901</a>&nbsp; 
</div>
</div>


I am using the instructions on the following link to populate the address text boxes (city, state, zip) in an address subform where there may be multiple address for a person.  The instructions work well for a single address but when I select the zip code it will populate the city, state, zip unbound text boxes for all of the address records for that person.  Is the a way to isolate writing to the text boxes for the particular address record?

http://support.microsoft.com/kb/322901  

Use Zip Code Lookup to Populate City, State, Zip text boxes in records on sub form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.