[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

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

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 
0
MarkSnark1
Asked:
MarkSnark1
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm assuming you're using a Datasheet or Continuous Subform? If so, then Unbound boxes will always show the same data. The textboxes will have to be "bound" to a datasource.

You can, of course, build a query that displays the full Address, including City/STate/Zip, and use that query to populate your form. You can then bind those boxes to the query's fields, and you should show the correct values in the subform.
0
 
MarkSnark1Author Commented:
Thank you LSMConsulting.  I bound the city, state, zip fields to the "address" table and obtained the desired results.
0
 
MarkSnark1Author Commented:
Thank you.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now