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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nafeesjan - 06 Nov 2006 12:59 GMT

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.

Reply to this Message

Allen Browne - 06 Nov 2006 13:04 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have an MS Access database to maintain enter / exit of employees.
>
[quoted text clipped - 7 lines]
>
> Regards.

Reply to this Message