Okay, I've done a bit of access work in the past, but I'm a little puzzled about where to start on this one. It has been requested that I create a form, and a report, that the office can use. The form is a shipping form. They want drop down lists or a way to reference addresses automatically - okay, they're lazy. There are typically two addresses that go with each name in the database. I need a way that someone can type in a name, and have the corresponding data be pulled. However, I don't want both address to be pulled, only one at a time (one is bussiness, one is home). Right now I have all the information in a table - rep name, home address, business address. I'm just not sure where to start looking. Should I use a VBA code or an SQL code, or do I need a code at all? I just need some ideas, does anyone have any?