I have created a form and a report for a database. The problem is I would like to print out one report at a time for the current data on the screen not for the entire database as it keeps trying to do. When I try to even just view a report for the current information on the screen it gives me the report for the first client in the database, not the current client I am looking at on the screen. If anyone can help me solve this problem, I would appreciate it!!

More than likely the control source of the report is your main table with no restrictions which is why it is showing everything. You need to modify the control source of the report so it only shows the name on the form. To change this, goto design view of the report and then select properties of the report. On the control source select the 3 dots just to the right and it will ask if you want to create a query. Select yes. The screen will change and show your table at the top and columns at the bottom. Move all of the fields in the table you want shown in the report to the columns. To restrict the records, there is a criteria field for each column. You need to restrict it for your clientID column (whatever the name of your column that is unique for your clients). In the criteria section you need to put in '[forms]![form name]![control name]' You will have to fill in the form name and control name. The control name from the form will contain the unique client name. Here is a link to a screenshot of a query builder: http://www.functionx.com/access/Lesson29.htm Scroll down to the Yugo National Bank.