Help and Information

[jonesa]

Hi I have created the following address book and search form that shows the details of each site based on the data valaidation box.

What I need help with is as follows.

• Using either a form Drop down or Activ x drop down how can I achieve the same thing as what I shown.
• How can I create another look up option to show all site details based on region for example, you select a region from the drop down box and it displays the details of all sites, address within that region. Bare in mind that in my source table the regions are duplicated as this is how the data was entered.
• Is is possible as when I search that the email address come up I can click on them that lunches outlook in order to use the email address
• Also is it possible to create your own data entry form in excel without using the built in feature. What I mean is I want to use a blank excel page as a data entry form to add new records etc to a database which would be on another sheet.