Print query reults

[sanjayakalpage]

Dear friends...
I have a form to get user inputs (criteria) and when the user hit a button it calls a query and show the results filtered based on the user's input. up to this point its working. at the query result page I need a button to print the results of the query and the report heading should mention the user's inputs (criteria which the report based), and the report generated date and time. Please help.... Thank you...

[rpeare]

What is the question?

If your query is working as you intend and your sticking point is getting the criteria to appear in the report heading you can retrieve the values the same way you would in using them as criteria in your query.

Let's say your form is 'frmReportCriteria', on that form you have a field Emp_ID for an employee ID

On your report you would have something like:

=iif(not isnull(forms!frmreportcriteria!emp_ID), "Report for Employee ID : " & forms!frmreportcriteria!emp_ID, "Report for ALL Employees")

[sanjayakalpage]

Thank u buddy.... It worked,,,,