Inserting into a table using values from comboboxes

[MsMope]

Good Morning,
I have 4 comboboxes on my form
cboEmployees
cboSystem
cboReason
cboType
these are bound to the corresponding tables with select statments ex:

SELECT Employees.EmployeeID, Employees.LastName FROM Employees;

I have another table called ChangeDetails, this tables stores the ID values from the 4 other tables, a DateChange, and Details field.

I have a button on my form btnAddRecord that when clicked I want it to append a record into the ChangeDetails table using the ID fields from the comboboxes, today's date and the text from the textbox on the form(details column), but I am unsure how to reference the ID fields from the combo boxes. Any suggestions?

 

[roppetech]

you should be able to reference the id field of comboboxes by:

cboEmployees.column(0)



- RoppeTech