In this case, the Combo box would be the preferred way to do it.
Create a combo that has two columns, the unique employee id (should ususally
be the primary key field for the employee table), and the employee name.
Now, here is the good part. You can use the combo to filter your report.
Don't put any filtering by employee in the report's record source query, do
it in the OpenReport method. If the combo is set up as suggested, the combo
will return the primary key value for the selected employee. You then use
that in the Where arguement of the OpenReport method:
Dim strWhere As String
strWhere = "[EmployeeID] = " & Me.cboEmployee
DoCmd.OpenReport "rptEmpReport", , , strWhere

Signature
Dave Hargis, Microsoft Access MVP
> I want to be able to print reports that contain only 1 employee's
> information. I have set up a query with a parameter to pull this information
[quoted text clipped - 3 lines]
>
> Any help you can give me would be appreciated!
Tellu - 28 May 2008 08:15 GMT
I have the same problem. I´d like to ask where should I put the Combo box?
This seems to be a little bit difficult for me...

Signature
Thanks a lot!
Tellu
"Klatuu" kirjoitti:
> In this case, the Combo box would be the preferred way to do it.
> Create a combo that has two columns, the unique employee id (should ususally
[quoted text clipped - 18 lines]
> >
> > Any help you can give me would be appreciated!
Klatuu - 28 May 2008 14:32 GMT
The combo box should go on a form with the command button. First you select
an employee then click the command button to run the report.

Signature
Dave Hargis, Microsoft Access MVP
> I have the same problem. I´d like to ask where should I put the Combo box?
> This seems to be a little bit difficult for me...
[quoted text clipped - 20 lines]
> > >
> > > Any help you can give me would be appreciated!