Results 1 to 2 of 2
  1. #1
    hlcarlin is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    12

    type mismatch error?

    Hello, I am trying to run this function
    Code:
     Dim stDocName As String
        Dim stLinkCriteria As String
    
        stDocName = "Business"
        
        stLinkCriteria = "[Numero_PA]=" & Me!
    [List_Participants] And "[SK_Year]=" & Me![Combo92]
        DoCmd.OpenForm stDocName, , , stLinkCriteria
    and I get the type mismatch error... I have looked up the fields in the tables and all of them are set to number.. any ideas as to whats going on?

    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Set a breakpoint and step through the code as it runs. Make sure the values coming from the form are what you expect. It could be you're getting a text value from one of them (or a Null perhaps).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. byref argument type mismatch error
    By karuppasamy in forum Access
    Replies: 1
    Last Post: 06-22-2011, 09:37 AM
  2. Data type mismatch error
    By AccessUser123 in forum Queries
    Replies: 1
    Last Post: 05-22-2011, 07:48 PM
  3. Data type mismatch error on all of my queries!
    By MarkGLyons in forum Queries
    Replies: 3
    Last Post: 12-27-2010, 01:27 PM
  4. Replies: 4
    Last Post: 10-26-2009, 05:27 AM
  5. Replies: 2
    Last Post: 03-23-2009, 05:39 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