Address Lookup

[rslewis]

Hi All

Have been searching for a way to allow an address to be looked up from a pre-defined table.

What I am looking for is that the user can type just part of the address into say, a text box, and are presented with all options which match so that they can chose the correct one. Once chosen I want the form to be populated with one or more fields from the selected record in the address table.

As I'm fairly new to access I may well be missing something really obvious using standard form/query functions etc but wouild be really grateful if anyone can point me in the right direction.

Thanks

Rob

 

[catalin.petrut]

First of all, the address should be "split" into the smallest parts, each part on a separeted field (street, number, city, state, etc).
Back to the problem: i would create a query with the complet address concatenated in a field. Then, the search will be made in a field based on the query, from the whole address. A button will be clicked after the selection of the right address and a form will be opened, based on the id field in the query, populating the new form. Maybe some vba code will be needed. Someone with a lil more knowlege will help more.

 

[rslewis]

Thanks Catalin

The address table already has the individual elements of the address and also a field with the concatenated address so a good start I guess.

I can run a query on this address line using:

Like "*" & [what address?] & "*"

Which does give me the list of matched addresses I need.

My next question is how do I then get a single address onto an existing form as part of my database. My scenario is this:

1. Type in partial address in box (which one do I need? Text/Combo?) on form and press FIND button to run query to select all matching addresses.

2. How do I get this list displayed and be able to select one?

3. When selected, how do I get the address populated into the same box on the form that the initial partial address was typed.

Thanks

Rob