Ice

You can search a database very rapidly.

First, you will need to manually create an Index for each "thing"
you might want to search for, such as
  • "zip"
  • "longitude"
  • "latitude"

Then, the following code snippet could be used "on demand".
It is written for DAO. I haven't worked with ADO, but I imagine
that it would be similar.
Code:
zip = Text1.Text
RS1.Index = "zip"
RS1.Seek "=", zip
If Not RS1.NoMatch Then
   < you have a match .. do something>
Else
   < no match was found .. do something else >
End If
It assumes the following
  • the name of the textbox you enter the desired zipcode is Text1
  • the name of your recordset is RS1

Change as required.
You could do similar things for longitude and latitude.

Hope that gives you some ideas.

Spoo