I have designed a report named report by Recruiter. I have made a form called frmRecruitmentReports, on this form I have created a pair of combo boxes .
1.Beggining Date (both are unbound)
2.Ending Date.
A query called recruitment query
The table being used is tblRecruitment the Field were criteria is initcontactdate
Argument:
Between [forms].[frmRecruitmentReports].[BeginningDate] And [forms].[frmRecruitmentReports].[EndingDate]
.
All this works fine when I enter dates. Once I pass the date fields I'm prompted
to enter a parameter value = Field Division and Recruiter ID. If I enter them manualy I get the results I want. But I want to place two combo boxes, Field Division and Recruiter Id so they can be selected right from the form.
On my report (Report by Recruiter) I have Field Division and Recruiter Id as Group Headers. I assume thats why I'm getting prompted to enter the paramater values. What I've done is ;
Created a query named FieldDivision From Field Division Table.
Created an unbound cbo box Named it Field Division.
At Row Source;
SELECT qryFieldDivision.FieldDivision FROM qryFieldDivision;
After all this has been done I'm still prompted to enter paramater values.
Can someone tell me what im doing wrong? What am I missing ?
Thanks