Form to generate report

[Neil Greenough]

I have an employees contact details and a subform which has a date and then
10 performance indicators listed.

I have designed a form with two combo boxes - an employee ID and a date.
This form also has a button on it which previews a report.

Now what I is, to be able to select an employee number and a date and then
click the button. I would like this to then generate a report for the
specific employee highlighting the performance indicators for the chosen
date.

Any ideas? I have designed the form and the report. I just need to link them
together now.

 

[Frank Stone]

hi,
you first need to write a query the select the
specific employee highlighting the performance indicators
for the chosen date. this will be the report record source.
in the query's criteria pane put this under employee:
[Forms]![yourform]![employeeid]
in the query's criteia pane for date put this
[Forms]![yourform]![date]
The query will use what you put in the form as criteria.
then on your button click event
docmd.openreport "yourreportname", acviewpreview
lookup openreport action in access help
lookup printout action in access help
hope this helps
regards
Frank

 

[Neil Greenough]

Frank,

I tried what you suggested but it didn't make such sense to be honest.

So I need to create a query listing the EmployeeID from my contacts form and
the date and performance factors from my subform? I then got lost with
inserting the [Forms]![yourform]![employeeid]. In my case would this be
[Forms]![Contacts]![EmployeeID]? I would ideally like to be able to search
by the inputted employee number rather than the automated employeeID. So,
could I write [Forms]![Contacts]![EmployeeNumber] ?

Thanks in advance

hi,
you first need to write a query the select the
specific employee highlighting the performance indicators
for the chosen date. this will be the report record source.
in the query's criteria pane put this under employee:
[Forms]![yourform]![employeeid]
in the query's criteia pane for date put this
[Forms]![yourform]![date]
The query will use what you put in the form as criteria.
then on your button click event
docmd.openreport "yourreportname", acviewpreview
lookup openreport action in access help
lookup printout action in access help
hope this helps
regards
Frank

-----Original Message-----
I have an employees contact details and a subform which has a date and then
10 performance indicators listed.

I have designed a form with two combo boxes - an employee ID and a date.
This form also has a button on it which previews a report.

Now what I is, to be able to select an employee number and a date and then
click the button. I would like this to then generate a report for the
specific employee highlighting the performance indicators for the chosen
date.

Any ideas? I have designed the form and the report. I just need to link them
together now.


.