how do i create input boxes that update information based on what i enter in other input boxes in access 97?

Question

ok im creating a database in access 97 for work. i was wonder how would i create a set of input boxes that when i type something in one input 2 other update infor mation like, i enter a zip code in one input and the state input and city input boxes update with the right information. i already have a database with all states, city and zip codes

Answer 1

Use the lost_focus event of the input box. When you finish typing the zip code, you hit tab, enter, or click the mouse somewhere, which moves the focus from the zip code box. When it loses focus, the event fires.

In the lost focus event, simply query your city/state/zip table for the zip code and set the other 2 inputs with the resulting city and state