Results 1 to 10 of 10
  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

    Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    I have the following code in a form procedure:

    I couldn

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    It would be helpful if you could post a stripped down copy of your database. In the meantime: is cboID2 a bound control or an unbound control?

  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: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    It is unbound. I use this same technique successfully in another form, It used to work in this form while still in development mode, I don

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    Sorry, no.

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

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    I

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    See <post#=488569>post 488569</post#>, first sentence.

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

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )


  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    Looks to me that none of the DLoopup will work.
    You should change all the where conditions out of the quotes :
    lngID = Nz(DLookup("[idsPayeeID]", "[tblSumServe]", _
    "[idsKeyOfSumServe] = " & form![cboID2] & "), "0")
    Francois

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

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    My Dlookup's seem to be working, however I tried your suggestion and got the following:

    Compiler error - Expected: list separator or )
    lngID = Nz(DLookup("[idsPayeeID]", "[tblSumServe]", _
    "[idsKeyOfSumServe] = " & form![cboID2] & "), "0")

    John

  10. #10
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Error 2424? ((a2k (9.0.6926) SP-3 Jet 4.0 SP-8) )

    Sorry, my mistake, should be :
    lngID = Nz(DLookup("[idsPayeeID]", "[tblSumServe]", _
    "[idsKeyOfSumServe] = " & form![cboID2] ), "0")
    if form!cboID2 is numeric
    If form!cboID2 is text then it should be :
    lngID = Nz(DLookup("[idsPayeeID]", "[tblSumServe]", _
    "[idsKeyOfSumServe] = " & Chr(34) & form![cboID2] & Chr(34)), "0")
    Francois

Posting Permissions

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