Results 1 to 3 of 3
  1. #1
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383

    Type Mismatch, Cant figure it out. On form after update,query runs fine.

    If [PaymentMethod] = "Discover" Or "Mastercard" Or "VISA" Then ' Disable Check Number Field if Credit Card is used.
    CheckNo.Enabled = False
    DoCmd.OpenForm "CreditCardInformation", acNormal


    End If

    Results in Type Mismatch error. Query form is based on runs fine. It is a combo with a list as above. If I open the query that the combo uses it works fine as well. Conclusion is my code I guess.

  2. #2
    DatabaseMakers is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Location
    London
    Posts
    12
    If [PaymentMethod] = "Discover" Or [PaymentMethod] ="Mastercard" Or [PaymentMethod] ="VISA" Then ' Disable Check Number Field if Credit Card is used.
    CheckNo.Enabled = False
    DoCmd.OpenForm "CreditCardInformation", acNormal
    End If

  3. #3
    burrina's Avatar
    burrina is offline VIP
    Windows 7 64bit Access 2002
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Thanks, that worked.

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

Similar Threads

  1. Query runs fine but report doesnt work
    By endri81 in forum Queries
    Replies: 4
    Last Post: 04-28-2012, 02:35 PM
  2. Type mismatch in query
    By SSharp in forum Queries
    Replies: 1
    Last Post: 04-23-2012, 04:29 PM
  3. Login form type mismatch
    By rafal in forum Access
    Replies: 11
    Last Post: 12-24-2010, 01:49 PM
  4. Data type mismatch in query
    By thart21 in forum Queries
    Replies: 8
    Last Post: 10-01-2010, 01:40 PM
  5. Type mismatch in expression /Query
    By Brian62 in forum Queries
    Replies: 4
    Last Post: 04-22-2010, 10:00 AM

Tags for this Thread

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