Results 1 to 2 of 2
  1. #1
    rbw95662 is offline Novice
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    4

    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.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    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

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums