Searching and selecting an address using postcode in a form

[Phil]

I've created a Table to hold various pieces of information, I also have a
table with addresses.

I would like to be able to enter the postcode in a form which would look up
the address table and return possible answers. Then I would like to be alble
to click on the right address and for the address details to be populated.

I've managed to create a form that shows the address options (after entry of
postcode) in a box at the bottom of the form I then have to copy and paste
the details......not ideal!

I hope this makes sense!

Can anyone help me?

 

[strive4peace]

Hi Phil,

make a listbox where the fiirst column is AddressID and it can be hidden
(ColumnWidth=0)

when a choice is made, simply fill in the AddressID that was chosen ...
all other information can be looked up at any time once you have the
AddressID

if, for instance, you have something like this for the RowSource of your
listbox:

SELECT AddressID, Address, City, State, Zip

Address --> = listbox_controlname.column(1)
City --> = listbox_controlname.column(2)
State --> = listbox_controlname.column(3)
Zip --> = listbox_controlname.column(4)

column inxeding starts with 0, which would be the AddressID


Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*