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.
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.