finding value of one field associated with a combo box for another

[kmims44]

I am attempting to create a form that has the following: I have multiple combo boxs to select "EmployeeAlias" (which is just first inital and last name of the employees) to thr right of each combo box I have text boxes labeled "Hours Needed" where the use can enter a numerical value. Now, what I want to happen is when the user is done filling out the form I want them to click a button that will multiply the Employees' labor rate by the number of hours they enter without displaying what each employees' labor rate actually is. How do I accomplish this? Do I need to have the labor rate field on the form as well and just hide it or do I have to use a command button to run VB to do a lookup of some kind?

[Missinglinq]

If the labor rate Field is included in the RecordSource for the Form, you can reference it as if it actually were on the Form, using the syntax Me.LaborRate.

If the labor rate Field were not included in the RecordSource for the Form, you'd use the DLookup() function to retrieve it.

Linq ;0)>

[kmims44]

i can accomplish my calculation for a single employee but I want the user to be able to select multiple employees on the form and I cant seem to create seperate form fields for each employee selection to calculate separately

[Missinglinq]

This really shouldn't be done using a Command Button and calculating the pay for all employees at one time. It should really be done by placing the Calculation in the AfterUpdate event of the Control where the Hours are entered. Then, as each employee's Hours are entered, the Calculation will be done automatically.

Linq ;0)>