Help with report problems

[brian0721]

Okay, im not really all that experienced with access, so this might be easy for everybody else, but here goes. I made a database for my boss at work. We store loan information, names, amounts, addresses, etc. In it, I have a report that will take the name, address, etc, and put it into a letter and print. Here is my problem, once we start having more than one name in the database, it wont print properly, because it is seeing more than one name in each field. How do i go about making it so that i can pick a certain name and then make the report use that information. Can i make a drop down list with the client names that automatically updates, and then will print a report for THAT SPECIFIC person? Any help would be greatly appreciated. This is very important. Thanks again!

 

[ddmcn]

CustomerID

Brian,

Do you have a primary key in the table that contains your customer names?

Do you send the letters out on an adhoc basis or are all letters produced at one time?

I think I can give you some help...but need more detail.

 

[brian0721]

We use a loan number that is 2-4 letters followed by 6 numbers. That is the primary key. The letters would be sent out at different times. For instance, sometimes we use letters to send out to verify employment, deposit, rent, etc. I want to have buttons in a form that will let me make the report use the information for the specific client that i am on. Thanks for any help!

 

[ddmcn]

Are the letters/reports run from a query? If so, you need to make sure the query includes the loan number...and the form you are looking at their data on should have the loan number on it. When you click on a button to run a report make sure the query's loan number field is equal to the forms loan number field...

the criteria in the loan number field on the query would read...

[queryname]![loan_number] = [forms]![yourform]![loan_number]

Another way to do this would be to attach the button to a macro...having only one action, OpenReport whose properties would be:

Report Name YourReportName
View PrintPreview
Where Condition [queryname]![loan_number] = [forms]![yourform]![loan_number]

Hope this helps...let me know if you have other questions.

Dennis