Can we use the parameters of active form (MS Access)for reporting

[Guest]

I have an MS Access database to maintain enter / exit of employees.

The user has to input the entry and then again repeat the particulars of
employee while printing the report.

Is it possible to first input the record (in entry form) and then print the
active record with one click without repeatidly entring the info of the
employee.

Regards.

 

[Allen Browne]

Sure. There are 2 approaches here.

The first is to refer to the text box on your form in the Criteria row of
your query, e.g.:
[Forms].[Form1].[Text0]
substituting the name of your form and text box.

The second approach is to add a button to the form, so you click it to open
the report. You can then use the WhereCondition of OpenReport to filter the
report to the desired record(s).

There's an example of both approaches in this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html