Address Entry Form

[ThomasK via AccessMonster.com]

I am trying to find the best way to design a particular form. Not so much the
technical aspects of the form (although thats always necessary), but the best
way as far as the form entry procedures for the user. I have a table for
addresses. It has the fields; address number, direction, street name,
building number, and suite. I also have a table for businesses as the many
side of the one to many relationship with the address table. One address can
have many businesses, and businesses with a particular address can leave and
another may take its place. So as you can see everthing is based on an
address. The business table has fields like business name.

What I need is for the user to be able to put in an address (in a form), hit
a comand button maybe (or before insert event), and then it would check for
and list all the addresses that were similar in a subform maybe. The user
would then be able to pick the address they wanted if it was listed, or if
none were listed use the one entered. The reason I need a list is that
sometimes the user may not have a building or suite number, but if there is
one you want to make sure it gets used.

My problem is trying to find a simple, user friendly, obvious way to do this.
Im sure that this must be a common type of form.

Thanks for the help.

 

[Jeanette Cunningham]

Hi Thomas,
one suggestion is to use a combo box.
After the use types in the number and address in the textbox, build the row
source of the combo to find all addresses that have the same street name in
them, or perhaps both the same street number and street name.
You could get the combo to open after the street and number have been
entered.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia