Finding a report by client ID

[orange]

Suggest you post a zip of the latest database.

[Burnsie]

Here you go (I think it's the right one )

[orange]

OK.
You have to include Payroll_Number in the query used for your Reports' Recordsource

In report design view, properties ...DATA.. Recordsource use this

SELECT tblClientDetails.Payroll_Number, tblClientDetails.[First name], tblClientDetails.Surname, tblClientDetails.Company, tblClientDetails.[Other_(State)], tblAssessmentdetails.Assessment_Date, tblAssessmentdetails.Weight, tblAssessmentdetails.BMI, tblAssessmentdetails.[Fat_fat_%], tblAssessmentdetails.Fat_Mass, tblAssessmentdetails.Visceral_fat_level, tblAssessmentdetails.Blood_pressure, tblAssessmentdetails.Cholesterol, tblAssessmentdetails.[Lung function], tblAssessmentdetails.Notes FROM tblClientDetails INNER JOIN tblAssessmentdetails ON tblClientDetails.Payroll_Number = tblAssessmentdetails.Payroll;

It' s similar to what you have, but it now includes tblClientDetails.Payroll_Number

[Burnsie]

OK.
You have to include Payroll_Number in the query used for your Reports' Recordsource

In report design view, properties ...DATA.. Recordsource use this

SELECT tblClientDetails.Payroll_Number, tblClientDetails.[First name], tblClientDetails.Surname, tblClientDetails.Company, tblClientDetails.[Other_(State)], tblAssessmentdetails.Assessment_Date, tblAssessmentdetails.Weight, tblAssessmentdetails.BMI, tblAssessmentdetails.[Fat_fat_%], tblAssessmentdetails.Fat_Mass, tblAssessmentdetails.Visceral_fat_level, tblAssessmentdetails.Blood_pressure, tblAssessmentdetails.Cholesterol, tblAssessmentdetails.[Lung function], tblAssessmentdetails.Notes FROM tblClientDetails INNER JOIN tblAssessmentdetails ON tblClientDetails.Payroll_Number = tblAssessmentdetails.Payroll;

It' s similar to what you have, but it now includes tblClientDetails.Payroll_Number

That's got it!

If I could buy you a virtual pint, I would

[Burnsie]

Oh NOOOO!!!!!

(hold that pint).

If I add another assessment data set (on my sub-form) for the client, I cant get to see it in report view and do not have the ability to navigate to it.

Any ideas?

....................

wait, it appears to be working now.....