Help with payroll form

[visidro]

I am a little green with access need help with our payroll form.

I would like to create a payroll record that collect some information from another table.
In other words:

I have an employee.
I have a payroll table.
I would like to get some of the values from the employee table written to the payroll table when a new record is entered.

The form would look some thing like this:
Three boxes:
Employee: [ ] (table query to find name) # of students [ ] #of class minutes [ ] (value list with 3 choices)
When the SAVE button is pressed a record would be written to the payroll table with:


The payroll table would look like this:
payrolid#, employee#, employee, # of students, # of class minutes, rate, date



The employee#, employee and the rate would come from the employee table.
The # of students, # of class minutes and date would come from the payroll form.

Your help is much appreciated.
victor

[June7]

Should not save the employee name to payroll table, only employee#.

Use a combobox with columns for the desired fields. Then code in the combobox AfterUpdate event can populate payroll table fields by referencing combobox column index. Index begins with 0.

Me![# of students] = Me.comboboxname.Column(2)
etc.

BTW, advise to avoid spaces and special characters/punctuation (underscore is exception) in naming convention. Better would be EmpNum or Emp_Num.

[visidro]

Not sure how to exactly code this in the afterupdate event.

Here is what my combobox with columns looks like:
SELECT Employees.EmployeeID, Employees.FirstName, Employees.LastName, Employees.BillingRate, Employees.active FROM Employees WHERE (((Employees.active)=0)) ORDER BY Employees.FirstName;

I need to get the firstname and billing rate from here.

Can you help me create the event procedure please.
thank you

[June7]

Why do you want to save name parts? That is duplication of data. I can understand saving the rate so that when the rate changes in the future the historical records are not changed.

BillingRate is in the 4th column so index is 3

Me!Rate = Me.comboboxname.Column(3)

[visidro]

I know ... I have reports and invoices already printing gathering all the data from one table. Much work to redesign all the reports and invoices.

I get a syntax error as soon as I choose an employee in the combobox (called: employee Name)

Private Sub Combo32_AfterUpdate()
Me![employee rate] = Me.[employee Name].Column(3)
End Sub

[visidro]

Compile Error: "Method or data member not found"

[June7]

Your combobox is named Combo32 not [employee Name].

[visidro]

Works great
thank you so much !!!!!