Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    4

    Unanswered: beforeUpdate event doesn't work

    My "beforeUpdate" event doesn't seem to work. As a test I tried the following two lines of code entering different temperatures on my input form. I expected to see different values, the first from the forms underlying table and the second from the control value entered on the form. I was surprised when the msgbox's displayed the same temperature values.


    Private Sub lastName_BeforeUpdate(Cancel As Integer)
    MsgBox [tableData_temp] '<--- from the forms base table
    MsgBox me!formData_temp '<--- from an input field
    End Sub

  2. #2
    Join Date
    May 2002
    Posts
    4
    The beforeUpdate event works fine, I just failed to use the <control>.OldValue property, as in ...

    me!formData_temp.OldValue

    My goal in using the "beforeUpdate" event was to retrieve a previous value and this is accomplished by use of <control>.OldValue.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •