Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Me.strClearedBy = Null (not working?) (a2k (9.0.6926) SP-3 Jet 4.0 SP-7)

    The following AfterUpdate code is giving the following error:

    Run time error, can

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Schenectady, New York, USA
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Me.strClearedBy = Null (not working?) (a2k (9.0.6926) SP-3 Jet 4.0 SP-

    Try
    Public Sub Cleared_AfterUpdate() 'Cleared Field

    If Cleared = True Then
    Me.strClearedBy = "M"
    Me.dteDateCleared = Date
    Else
    Me.strClearedBy = ""
    Me.dteDateCleared = ""
    End If

    End Sub
    Don
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18> <img src=/S/flags/NewYork.gif border=0 alt=NewYork width=30 height=18> "Life on Earth is expensive, but at least it includes a free trip around the Sun."

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Me.strClearedBy = Null (not working?) (a2k (9.0.6926) SP-3 Jet 4.0 SP-

    This is a third party system I'm modifying

    After further review I found:

    Private Sub Form_Open(Cancel As Integer)

    Cleared_AfterUpdate

    End Sub

    So the code I added in previous post was getting fired at form open time

    Thanks, John

Posting Permissions

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