Address Fields on a Report.

[mmp]

I'm definitely not an expert in Access - need to take a class, so the following question may seem very simple to anyone else.

I have a table with the following columns of nformation: Customer Name, Street Address, P. O. Box, City, State, Zip and Contact. I'm trying to create a form or a report where a combo box would pull down and you could choose whatever customer and then under that would be another text box with the Street Address (pulling in the correct address of the customer,and have this done for all the other fields as well. I don't want everything in one text box. How can I accomplish this? I'm sure it's possible. On another note, I'm not sure if I need to create both a form and a report to accomplish what I'm wanting to do, and that is to create Debit Memo's. I want to also save each Debit Memo for the year so I don't want it be overwritten with anything else. Right now we have this created in MS Works and Works is not working out well. We end up having to take the information from the list view and copying and pasting it into Excel. This is a waste of time. PLus, having this in Access will allow us to easily print labels, etc...Can anyone help me out with this?

 

[RickSpr]

First, you probably don't want a report here. You want interaction with the user, but reports are for printing on paper, and no user interaction is involved.

Have you created a table for the debit memos yet? If so, does it have a foreign key for the customers table, and is it the record source for the form you describe? You should understand the need for these things before continuing.

The Northwind sample database installed with Access contains examples of how to use a combo box to populate customer fields in an order. Have you examined the technique used? Rick Sprague