inserting data from form into table

[maisam]

i have a problem adding the data from the fiels on the form into a table. I know you can just click on the navigation arrows and it will save the record but i want to use a submit button as this is more user-friendly and suitable for the work i'm doing.

I have attached the database... the form that needs the code for submit button is 'frmNew_JobStatus' and the table i'm trying to insert the data into is 'tblJobStatus'

can anybody have a look at what i've done so far and suggest how i can fix this... sample code would be very usefull as i'm not an access expert.

thank you all

 

[GUIDO22]

Add a command button and behind the click event() put :

DoCmd.RunCommand acCmdSaveRecord

' if you want to automatically move to a new record after the save

DoCmd.GoToRecord acDataForm, Me.Parent.Name, acNewRec