insertion of value form to table

[khan33]

Dear,

Can any one explain the method of entering values available in different boxes on a form to relevant table attribute.

Q 1. Entering whole tuple?
e.g. EmployeeName, EmployeeId,Salary

Q 2. Updating some attribute?
e.g. Updating Salary of EmployeeName = "ABCD"

I have already used under given method but now looking some more sophisticated method.

Dim rs As DAO.Recordset
Set rs = Currentdb.OpenRecordset("MyOtherTable", dbOpenDynaset)
With rs
.AddNew
!TableField1 = Me.FormControl1
!TableField2 = Me.FormControl2
... etc
.Update
.Close
End With
Set rs = Nothing

-------------

 

[Galaxiom]

Any reason you are not using bound forms?