Printing From a Form Selecting drop down box

[eimbert]

I have designed a report named report by Recruiter. I have made a form called frmRecruitmentR eports, 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].[frmRecruitmentR eports].[BeginningDate] And [forms].[frmRecruitmentR eports].[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 qryFieldDivisio n.FieldDivision FROM qryFieldDivisio n;

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

[tcveltma]

I think parameter promts in forms happen when your source isn't spelled exactly the same way.

[Scott Price]

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 qryFieldDivisio n.FieldDivision FROM qryFieldDivisio n;

You are probably getting your parameter prompts because your RowSource isn't set quite right. In your query named qryFieldDivisio n, you will normally select two fields/columns to display, in this order: FieldDivisionID , FieldDivision. Then set the RowSource to qryFieldDivisio n. Give it 2 columns, make the column widths 0", 1.5", set bound column to 1, limit to list = yes, column headings = no.

In the row source you have listed, you are trying to essentially duplicate the select query that you have already created.

The two ways to set your row source are: set row source to query name like I first mentioned OR use a SELECT statement in the row source itself, in this way: SELECT FieldDivisionID , FieldDivision FROM tblFieldDivisio n.

Hope this helps!

Regards,
Scott