strSQL = " INSERT INTO SYSADM_PS_ADP_CONTRACTORS (EMPLID,EFFDT,NATIONAL_ID,NAME,PER_STATUS,ORIG_HIR E_DT,HIRE_DT,BIRTHDATE,REHIRE_DT,TERMINATION_DT,DE PTID,JOBCODE,EMPL_STATUS,ACTION,ACTION_DT,ACTION_R EASON,LOCATION,EMPL_TYPE,DEPTNAME,DEPTNAME_ABBRV,M ANAGER_ID)"

strSQL = strSQL & " VALUES (EMPLID,NOW(),NATIONAL_ID,NAME,'E',ORIG_HIRE_DT,OR IG_HIRE_DT,BIRTHDATE,'',TERMINATION_DT,'123','123' ,'A',ACTION,'','',LOCATION,'H','IT','IT',MANAGER_I D)"

DoCmd****nSQL strSQL

MsgBox ("Your Detail have been saved!")
Me.Refresh

I wish to insert some values in SYSADM_PS_ADP_CONTRACTORS table by entering data in a form.

My problem
========
Some of the values are hard coded and some of them i need user to enter their particulars.

The system seems like don't know where should the value to be inserted but it an display the message"Your Detial ....".

When the time i check back my table,i can't find the new particulars of mine.