Report Design/Lookup Data

[slam41]

I have built a database to keep track of employee work refusal. My report
shows all employees. I want to be able to type in a name and pull up all
information by that name and not have to view all employees. Does anyone have
a suggestion?

 

[John Vinson]

I have built a database to keep track of employee work refusal. My report
shows all employees. I want to be able to type in a name and pull up all
information by that name and not have to view all employees. Does anyone have
a suggestion?

Base the Report on a Query which uses a criterion such as

[Enter employee name:]

as a criterion.

Or - better, since it will avoid problems with spelling out the whole
name and getting it right - create a small unbound form frmCrit, with
a combo box cboEmployee. This combo should display the employee's name
but should have the unique EmployeeID as its bound column. Use a Query
with a criterion

=Forms!frmCrit!cboEmployee

as a criterion on the employeeID; base the Report on this query, and
put a command button on frmCrit to launch the report. This will let
you just pull the name from a list rather than having to type it all
in.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Ted Allen]

You can use a query for the record source of your report, and enter a
parameter for the criteria of the employee name. By doing that, you will be
prompted for an employee name automatically when you run the report.

HTH, Ted Allen