Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Europe
    Posts
    369

    Unanswered: Which event handles record change?

    I cannot seem to find an event that handles recordlevel - or even fieldlevel) canges.

    When moving from one record to another in a form, which event can be used to control changes in apperance for individual controls based on the value that appears in the control when the other record appears?

    I have the following code:

    If Me.txtBalance.Value < 0 Then
    Me.txtBalance.BackColor = 13434828
    Else
    Me.txtBalance.BackColor = 8421631


    But do not know where to put it...

    Daniel.

  2. #2
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133
    Use your FORM's Current event.

Posting Permissions

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