Results 1 to 4 of 4

Thread: IsNothing (97)

  1. #1
    amandag
    Guest

    IsNothing (97)

    I am trying to test to see if a collection is set or not - I am using the following code
    If isnothing(OldRecords) Then
    where OldRecords is the name of a collection
    But I keep getting the error message Sub or function not defined. Can any one suggest what I am doing wrong.
    thanks in advance

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: IsNothing (97)

    Try splitting the Isnothing into 2 words, i.e. Is Nothing

    Amdrew C

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IsNothing (97)

    The correct syntax would be:

    <pre> If OldRecords Is Nothing Then
    </pre>

    Legare Coleman

  4. #4
    amandag
    Guest

    Re: IsNothing (97)

    Thanks for your help
    The following is working now just as I want it

    If Not OldRecords Is Nothing Then

Posting Permissions

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