Using Forms to Select Report Criteria

[Mark Drayton]

Hi,

This is another easy one, as long as you know what your doing!

I want to use a form with:

Date options ie between date 1 & date 2
Status options ie an issue is either open, closed or pended
Assigned to option ie a person's name

... to drive what is shown on a report.

I realise that the form needs to show 'unbound' combo's etc but am wondering how this is linked to the report.

Just a bit confused and in need of direction. Hope this makes sense!

Thanks in advance

Mark

 

[Mile-O]

Put the parameters into a query and base the report on the query

So for dates the criteria in the query would be:

Between [Forms]![MyForm]![txtStartDate] And [Forms]![MyForm]![txtEndDate]

For others just put the control:

[Forms]![MyForm]![cboUsers]

 

[Mark Drayton]

Thanks Mile-O-Phile,

I'll try that.

The reason I want to a form is to provide the 'user' with a front end for the reports - make it look sexy or something like that!

Ta

Mark