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?
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.