Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    9

    Unanswered: Run-time error '2001'

    Anyone see the reason I'm getting Run-time error '2001'?

    "StudentsPerClass" is a query and one of the fields is the count function on the field "EmployeeID." "Class" and "section" are 2 more fields in the query and both are text.

    Thanks in advance.
    ~C

    Code:
        
    temp1 = Nz(DLookup("[Count Of EmployeeID]", "StudentsPerClass", "[Class] = '" & Combo4 & "' AND [Section] = '" & Text7 & "'"), 0)

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What is error 2001?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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