Results 1 to 3 of 3
  1. #1
    Trojnfn is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    46

    Invalid Procedure Call or Argument

    I keep getting this error when I attempt to submit data entered in a form. I have a Add Record button and in the property data tab, onClick, I have a event procedure that has these five lines:
    Private Sub BtnAddRecord_Click()
    MsgBox "Record Added Successfully."
    Me.Fileter = "(False)"
    Me.FilterOn = True
    End Sub



    I copied this from another form I have and it works, the message is displayed. However, it does not work on this new from. Are there any other settings that need to be set ? If not, what do I look for and what do I do ?

  2. #2
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    When you get your error message, click "Debug" to see which line of code is causing the problem. If you are not even seeing the result of the MsgBox, the error is somewhere else.

    John

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Me.Fileter = "(False)"
    Check spelling... Should be Me.FILTER =

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 9
    Last Post: 08-10-2012, 03:10 AM
  2. Dedupe Query - Invalid Procedure Call
    By icarus in forum Queries
    Replies: 0
    Last Post: 12-07-2011, 08:49 AM
  3. Invalid Procedure Call
    By neo651 in forum Queries
    Replies: 21
    Last Post: 09-11-2011, 12:58 PM
  4. Access 2007 Append Query Invalid Procedure Call
    By forrestapi in forum Queries
    Replies: 1
    Last Post: 05-13-2011, 07:53 AM
  5. invalid procedure call
    By johnmerlino in forum Access
    Replies: 5
    Last Post: 12-13-2010, 10:12 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums