considering your done declaring all necessary variables (connection, recordsets...etc.) after updating (which you would assign all the inputs to a table) ex. serial no is into rs!serial_no...then assign the datagrid's recordset to the active recordset in which you save your data. in this example, rs. Set the datagrid into "not" updatable for the user can't mess up your data. (i'll try to give a very simple example so even the noobs can understand.)
Private Sub cmdSend_Click()
rs.Addnew
rs!serial_no = txtserialno.text
rs!defect_mode = cmbdefect_mode.text
rs!location = txtlocation.text
rs!pin_no = txtpin_no.text
rs!rework = cmbrework.text
rs!icpn = txticpn.text
rs!nlc = txtnlc.text
rs.Update
Set Datagrid1.Datasource = rs
End Sub
Hope you understand what i'm trying to tell....
