Access 97, auto-populating form fields?

I am trying to build a form in Access 97 that will automatically populate address, city, state, and zipcode values based on selecting a company from a dropdown. I have tried to use SetValue and connected the field to a query to select the correct value from the tables, but I get an error when the macro runs that says the query is not a part of the application. Can anyone suggest the correct approach here?