Results 1 to 2 of 2
  1. #1
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Dirty Record? (2002)

    I have the following code (partial) in the form On Current event:
    <pre>If [blnGraduate] = False And [dtmEnd] < (Date + 1) And [blnDropped] = False Then
    Me.txtClassAlert.Visible = True
    Else
    Me.txtClassAlert.Visible = False
    End If</pre>

    txtClassAlert is a hidden text box that displays a msg when the three conditions are met in the code. The problem I'm having is that the "visible" condition is only fired when the form is closed, not when any of the three conditions are changed. I have If Me.Dirty set to save record in the same event of the form.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  2. #2
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Dirty Record? (2002)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Forgot to include the same code in the After Update event of the controls.
    All is well.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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