-
Looking up a zipcode
Hi - I have a form that uses an update query with a parameter that will ask for the user's zipcode. The zipcode the user inputs will lookup the zipcode in a table that has the zipcode, city and state. Then the query will place the city, state and zipcode in the table that holds the user information. When I run the query in standalone mode it works just like I want it too, but when I use the combobox wizard to create the unbound combobox and select the query I receive an error message that the query contains no valid entries. Any and all help or suggestions are greatly appreciated.
-
What is the Criteria for Zip field that you have given? Although you have not given sufficent details try this out for your criteria.
Forms!YourFormName!ComboBoxName
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules