>Still having problems with report detail bars. I have a master database that I show in a form and you can use navigation buttons to go to the next or previous record. Each time you select a new record, I have set relation to for the child database and it shows the child records in a grid. All works fine on the screen. I have a [print] button to print the current record from the master database with all the associated records from the child database. If I use "report form name.fx NEXT 1 to printer, It prints the master record fine, but I only get one of the associated child records to print. Does the detail band also adhere to the NEXT 1 option and if it does, how can you print just the currect master record with all the child records?

You might try creating a SQL Select statement, pass the parent and let it pull the child records.

1. Create a method on your form to hold your SQL Statement.

2. Within that method you do your REPORT FORM myform (no next 1 required)

3. Do not use aliases for your report text boses. Example: If you use MyData.City to drive a text box, remove MyData and just use City. That allows you to use the report with different Tables and Cursors with the same field layour but different names.

Tom