Suggest you post a zip of the latest database.
Suggest you post a zip of the latest database.
Here you go (I think it's the right one )
OK.
You have to include Payroll_Number in the query used for your Reports' Recordsource
In report design view, properties ...DATA.. Recordsource use this
It' s similar to what you have, but it now includes tblClientDetails.Payroll_NumberCode: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;
That's got it!OK.
You have to include Payroll_Number in the query used for your Reports' Recordsource
In report design view, properties ...DATA.. Recordsource use this
It' s similar to what you have, but it now includes tblClientDetails.Payroll_NumberCode: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;
If I could buy you a virtual pint, I would
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.....