Populate form based on combo box

[Amir]

Hi,
First I just wanna thank all the people that have helped
me numerous time before, and hopefully now to
My question this time would be about populating continuous
form based on list from combo box... Let me explain.
I have continuous form that is used for entering time for
employees by supervisor, supervisor would select employee
form combo box and then enter their hours worked, annual,
etc in other fields for that record.. If supervisor has a
small department that is not a problem, but some
departments have a 20-30 people in their department and
they would select one by one each of their employees. I
would like to "make" new records based on list of people
that they have in that combo box.
So if super would open the form and maybe click on
something that will generate records for each employee.
I already have HoursWorked defaulted to 8, they would make
modification to that as neccessary.
I'm not sure if that is something that can be done or how
to go about doing it.
Thank you.

 

[Ragnar Midtskogen]

Hello Amir,

I don't know all the details of your application or how you have organized
you data, but I would have use four tables like this
1. Employees, with an employee ID field with a unique id for each employee.
Also a department ID field, along with employee name, pay rate and other
info unique to each employee.
2. Departments, with a deparment ID field with a unique department id, and
also supervisor id.
3. Supervisors, with a Supervisor ID field with a unique id for each
supervisor.
3. Hours Worked, with fields for employee id, deparment id, week ending
date, and hours worked.
To start entering time, the supervisor would select department from a combo.
That would populate the employee combo, selecting only employees for the
selcted department.
I would use a single form with fields for one employee and make it unbased.
When an employee was selected
the ID, name, week ending date and default hours would be inserted by code
into the form, using recordsets as data source.
When the data was correct, the supervisor would click a Save button, whick
would use a recordset to copy the data to the Hours Worked table and clear
the data entry form.
The Hours Worked would be diplayed in a subform, below the data entry form,
and updated whenever a new entry was saved.

Ragnar

 

[Amir]

I shall try this... sorry about the delay..
Thank you.