Report Printing all data from subform

[DallasW]

I am very new at Access. I am creating a database to keep, Managers, Advisors, Corrective Actions (Performance, Attendance, End of Assignments). I have tables, Managers, Advisors, Performance, Performance Details, Attendance, and Attendance Details. I am having several issues with the Corrective Action form for Performance and Attendance. In the form, I have boxes for all the data in Main table for both Attendance and Performance, then a subform for the Performance detail and Attendance details. (Separate forms for Attendance and Performance as the information required is different). The forms are pretty basic, as I just want to currently get the Information into the report accordingly. In the reports, all of the information shows up. The problem being that instead of just the information from the form, it is populating all of the subform information from previous entries. Then in the print preview, the form is printing the same number of time as there are entries in the subform. Any help would be great and greatly appreciated.

[June7]

Apply filter criteria to report if you don't want all records.

Which report?

[DallasW]

Both the Performance Report with subform, and Attendance Report with subform are giving me the same issues.

[June7]

You mean subreports.

There are no records in Attendance CA, makes it difficult to test. No records show on the report. Why would there be records in Attendance CA Details but no parent record in Attendance CA?

The Performance CA Details table does not have foreign key data for Performance CA.

The subreport RecordSource does not need to include the parent table (Attendance CA or Peformance CA) but in this case should not hurt.

The Attendance tables are not in the Relationships builder.

There is a link between Advisors and Managers on their autonumber ID PK fields. Cannot link tables on two autonumber fields. Why would you want a link between these two tables?

[DallasW]

I did mean subreports.

I removed all the main records from attendance, I guess I forgot to remove the one's out of the Details section.

I thought there was a foreign key data for Performance CA, using the Performance CA Key.

I wanted to get Performance Cleared up and working correctly, so I could copy the design, and filters to Attendance.

I don't know why the Advisors and Managers autonumbers are linked, as it probably happened when I was messing with different queries.

[DallasW]

I have updated Performance Report, it is now showing the correct data in the sub report, but I am still having issues with the filter to only show the information from the form. It is now showing all entries to the Main Performance CA table. I had tried filter [Forms]![Performance Corrective Action]![Performance ID].

[June7]

The Performance form is set for DataEntry which means existing records will not display. Is this what you want? Also, the form has criteria in the Filter property. Is this also intended?

The report Filter property must have an expression that includes the field to apply filter:

[PerformanceCA ID]=[Forms]![Performance Corrective Action].[Performance ID]

Since the form is set as popup, the report gets stuck behind the form. I don't use Tabbed Documents db property, I use Overlapping Windows.

[DallasW]

What I want is for a person to be able to enter data into the form, and then click the preview button, and then that information that was entered, show up in the Performance report.

[June7]

Record must be committed to table first.

DoCmd.RunCommand acCmdSaveRecord

[DallasW]

Thanks June for all the great information. The Form is saving to the table, and the report does show the information enter in to the Main Form, and Subform from the Main table, but it is also showing all the previous entries from the Main table.

[June7]

Opening the report directly from the navigation pane works because report was saved with the correct expression in Filter property.

The WHERE condition in the embedded macro is wrong. Need the expression described in post 7. Apparently that is how the Filter property originally got set and it is overriding the saved filter criteria.