Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-13-2018, 08:49 AM   #1
PatAccess
Newly Registered User
 
Join Date: May 2017
Posts: 124
Thanks: 101
Thanked 1 Time in 1 Post
PatAccess is on a distinguished road
Error 13: Type mismatch

Hello Guys,

Here my code:
Private Sub Command131_Click()
DoCmd.OpenForm "Frm_CorpUpdateLogin", , , "[ID]=" & Me.ID & "" And "CorpLicID=" & Me.CorpLicID & "" And "StateLic=" & Me.StateLic & ""
End Sub

I get error code type mismatch
the ID is an autonumber all the rest are numbers. I've tried every which way but I still get the same error

What am I missing?

Thanks in advance!

PatAccess is offline   Reply With Quote
Old 07-13-2018, 08:53 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,929
Thanks: 9
Thanked 3,844 Times in 3,787 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Error 13: Type mismatch

The doubled-up quotes will cause a problem.

Edit: plus you don't want the quotes between And and the next field name.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
PatAccess (07-13-2018)
Old 07-13-2018, 10:14 AM   #3
PatAccess
Newly Registered User
 
Join Date: May 2017
Posts: 124
Thanks: 101
Thanked 1 Time in 1 Post
PatAccess is on a distinguished road
Re: Error 13: Type mismatch

Thank you...It worked

PatAccess is offline   Reply With Quote
Old 07-13-2018, 10:16 AM   #4
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 31,929
Thanks: 9
Thanked 3,844 Times in 3,787 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Error 13: Type mismatch

Happy to help!

__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Type Mismatch Error BrianFawcett Modules & VBA 3 04-14-2011 05:15 AM
Error Importing: 'mx_FrmMain:Form' (Type Mismatch Error) PSUIVERSON General 5 11-18-2008 07:34 AM
Type Mismatch Error - Please help :( systematic Modules & VBA 8 05-14-2006 09:07 PM
Type mismatch error belsha Modules & VBA 0 04-28-2004 08:39 AM
type mismatch error maya Forms 4 08-19-2003 12:12 AM




All times are GMT -8. The time now is 10:42 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World