1 Private Sub OddDesc_AfterUpdate()
2 Dim db As dao.database
3 Dim rs As dao.Recordset
4 Set db = CurrentDb()
5 Set rs = db.openrecordset("select * from addmanage")
6 If Me.OddManage = 5 Then
7 With rs
8 .AddNew
9 rs.Fields("serial") = Me.OddManage.Value
10 rs.Fields("manage") = Me.OddDesc.Value
11 .Update
12 End With
13 End If