Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


There are many differences between Access and Base. Although "OldValue" is not part of Base you can still obtain the data in the field before it is actually changed by using a macro attached to the Before updating event of the field. A simple example:

Sub BeforeUpdating
    Dim oForm     As Object
    Dim oColumn As Object
    oForm = ThisComponent.Drawpage.Forms.getByName("YOUR_INTERNAL_FORM_NAME")
    oColumn = oForm.Columns
    Print oColumn.getByIndex(INDEX # Relative to 0).getString()  Rem Field being updated
End Sub