Populate Field Based on Input from Another Field

Two questions: 1) I have a table "tblZipcodes" with 3 fields: City, State, Zipcode. When entering/editing a record, the user completes the Zipcode field first on the data entry form. I want the City and State fields to auomatically populate based on the entered Zipcode. 2) I have a report based on a query. When the report runs, it prompts the user to enter a value. How do I change this text box prompt to a drop down menu prompt that pulls its values from a table? ## Deliverables 1) Provide instructions on how to popluate a form field based on input from another form field. 2) Provide instructions how to change a test box prompt to a drop down menu prompt populated from table. ## Platform Windows