Serious Sam
New Member
- Joined
- Jan 19, 2005
- Messages
- 30
Hello,
I have a Timesheet database and I'm trying to build a function that allows
a batch of timesheets to be produced with the click of a button.
The process goes like this:
1. A form has a text box where the WeekEnding Date is entered.
2. The form also has a combo box where the Departments are listed.
3. When a Department is selected, another combo box is re-queried and lists the Employees in that department.
4. A command button then opens a timecard form. This is where the hours and allowances are entered.
I've got an auto-populate function that puts the standard hours for the selected employee into the form.
(Thanks to Denis the SydneyGeek, for showing me how to get the auto-populate to work when the form is opened.)
The next step I'm working on is to use the values listed in the Employee combo box value and get them one by one into the Employee input box of the timecard form, so the following happens:
1. Create a new timecard with the first person from the Employee combo
2. Run the autopopulate function for that employee
3. Create a new timecard with the next person from the Employee combo
4. Run the autopopulate for that employee
...and so on for all people listed in the Employee combo.
Can anyone help get combo box items into a form text box?
I have a Timesheet database and I'm trying to build a function that allows
a batch of timesheets to be produced with the click of a button.
The process goes like this:
1. A form has a text box where the WeekEnding Date is entered.
2. The form also has a combo box where the Departments are listed.
3. When a Department is selected, another combo box is re-queried and lists the Employees in that department.
4. A command button then opens a timecard form. This is where the hours and allowances are entered.
I've got an auto-populate function that puts the standard hours for the selected employee into the form.
(Thanks to Denis the SydneyGeek, for showing me how to get the auto-populate to work when the form is opened.)
The next step I'm working on is to use the values listed in the Employee combo box value and get them one by one into the Employee input box of the timecard form, so the following happens:
1. Create a new timecard with the first person from the Employee combo
2. Run the autopopulate function for that employee
3. Create a new timecard with the next person from the Employee combo
4. Run the autopopulate for that employee
...and so on for all people listed in the Employee combo.
Can anyone help get combo box items into a form text box?