adding record via form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I would like to use a form to enter data into a SQL Server table. On the
form, i've a combo box that pull in the emp_id from table A and three text
boxes, which allow the user to fill in the information (hire_date, SSN,
salary). Once the user enter the data into the three text boxes, they can
click a button to submit the data. i would like to know what vba code do i
need behind the button to take the emp_id, hire_date, SSN and salary and add
these to a new table (table B). Your help/suggestion is greatly appreciated.
.

Quantcast