Hello.
I have a form called Task Details, which has a field called ID. Internally, we call the ID the Job Request ID.
I have a form called TasksDNA, which appears as a subform in the Task Details form. It has a field called JobRequestID.
I am creating a report for Task Details. I have all of the data from Task Details form present, including a textbox with the source control of ID. I also added a subform/subreport field, and set the source to form.TasksDNA. I set Link Master Fields to ID, and Link Child Fields to JobRequestID. This relationship also exists in the database schema in Access, and it works properly in the form Tasks Details . However, it's not working in the report. It is not filtering any data and is simply a blank gridview.
I did a test and unchecked Filter on Empty Master and it is displaying all data in the form TasksDNA. It would appear that the subform is not properly associating JobRequests with the ID field, although I even added a textbox with the source ID to make sure it would have data to filter the subform by.
Any suggestions?