Hi All
I have a table called "table 1". It has two column in it
1. ID
2. Name
All I want is if someone changes a field in "table1" then to bring back two message boxes stating the old value and new value.
I believe this can be done with the OriginalValues property?
Can anyone help?
I have a table called "table 1". It has two column in it
1. ID
2. Name
All I want is if someone changes a field in "table1" then to bring back two message boxes stating the old value and new value.
I believe this can be done with the OriginalValues property?
Can anyone help?
Code:
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim fld As DAO.Field
Set db = CurrentDb
Set rst = db.OpenRecordset("Table1")
' i.e. Msgbox old value
' i.e. Msgbox new value
'MsgBox fld.OriginalValue