Open form based on another form

B

Bruce

I have the following tables in my database:
tblEmployees
EmployeeID (PK)
First
Last
Department
etc.

tblMonthlyEval
EvalID (PK)
EmployeeID (FK)
Subject
Date
etc.

tblEmployees is related to tblMonthlyEval one-to-many

I have the following forms:
frmListByDept
frmMonthlyEval

The MonthlyEval objects are for storing and displaying subject, date, etc.
of monthly employee evaluations. frmListByDept is based on qryEmployees,
which is in turn based on tblEmployees. frmListByDept contains an unbound
text box which is used to filter by Department. The idea is that a
supervisor will select the department and see a list of all employees in that
department. Each employee is a separate record in continuous form view. I
have done that. Now I would like to be able to click a command button next
to an employee's name and open frmMonthlyEval with that employee's name
already filled in, and EmployeeID bound to the appropriate field in
tblMonthlyEval.
I say I want to use a command button to open the evaluation form, but that
is not required as long as I have a simple way for the supervisor to open the
form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top