Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009
    Posts
    32

    Unanswered: Runtime Error 424

    Its a day for Errors!!!


    I have this code that works in a form as a sub but i needed to use put it in the db's mod and im having trouble and im getting the 424

    Dim Callid As Integer
    Dim intCounter As Integer
    Dim leadNum As Integer


    Set leadNum = Form![New Call Form]!lstLeads.ListCount() <-- error 424
    Set Callid = Form![New Call Form]!txtCallID

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    It should be Forms![...
    Have a nice day!

  3. #3
    Join Date
    Nov 2009
    Posts
    32
    Yea i fixed that and still get the error

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    And like this ?
    Code:
    Set leadNum = Forms![New Call Form]!lstLeads.ListCount
    Have a nice day!

  5. #5
    Join Date
    Nov 2009
    Posts
    32
    I got it to work. I had to rename the form to frmnewcallform to make

    Set leadNum = Forms!frmnewcallform!lstLeads.ListCount

    Cant believe it took me all day to figure that out...

Posting Permissions

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