Need to populate two fields in a table from a form/combo box (access 2007)

[Jules1334]

Hi. I have a table called tbl_Employee with Two fields - EmployeeName and EmployeeID

I have a form called frm_AuthEmploye es where I need my user to pull down the EmployeeName from a combobox and store the EmployeeID and EmployeeName in tbl_Employee OR EmployeeID at the very least.

I can accomplish storing the EmployeeID when I create a two-column combo box, but I need the user to be able to type the EmployeeName in the combo box field.

Any help would be appreciated.

Thanks!

[RuralGuy]

THe ComboBox wizard knows hown to accomplish what you want. Have you tried it?