Using combo box values in a loop

[Serious Sam]

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?

 

[MyBoo]

Can anyone help get combo box items into a form text box?

Me!FormTextBox1 = Me!EmpCombo.column(0)
Me!FormTextBox2 = Me!EmpCombo.column(1)

If your intention is to auto-populate the timecards for each Employee in the selected Department.... why do you need the Employee Combo box?

You could create a recordset, pulling Employee information, based on the selected Department. Then loop through each new timecard, feeding Employee data from the recordset.