Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > Data type misma...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 41541 of 43413
Post > Topic >>

Data type mismatch in criteria expression

by benjaminkmartin@[EMAIL PROTECTED] Aug 7, 2008 at 08:08 AM

I'm getting an error that I don't know how to deal with.

I think the error has something to do with the coding in my
AfterUpdate event of combo28 which is as follows...

Private Sub Combo28_AfterUpdate()
  Combo36.RowSource = "SELECT [Location ID].[Location Name], [Location
ID].[Location Code] FROM [Location ID] where [Location ID].[Vehicle
ID] = " & Combo28.Column(1) & ";"
  Combo36.Requery
End Sub

When I click on combo36 I get the error message, "Data type mismatch
in criteria expression."  I thought maybe the problem was that the
Vehicle ID of one table was numeric while the other was text.  But
they are both set as text as I would like them to be.  There's even an
established relation****p between the Vehicle ID's of each table (the
two tables are "Vehicle ID" and "Location ID").  So I have no idea why
the Vehicle ID from combo28.column(1) (this combobox pulls it's
choices from table "Vehicle ID) does not match up with the Vehicle
ID's from the table "Location ID"

Any thoughts?  (And any bit of information is helpful!)

Thanks so much!
 




 6 Posts in Topic:
Data type mismatch in criteria expression
benjaminkmartin@[EMAIL PR  2008-08-07 08:08:57 
Re: Data type mismatch in criteria expression
"Damon Heron" &  2008-08-07 08:31:32 
Re: Data type mismatch in criteria expression
benjaminkmartin@[EMAIL PR  2008-08-07 08:39:43 
Re: Data type mismatch in criteria expression
"Douglas J. Steele&q  2008-08-07 12:06:08 
Re: Data type mismatch in criteria expression
benjaminkmartin@[EMAIL PR  2008-08-07 09:19:43 
Re: Data type mismatch in criteria expression
"Douglas J. Steele&q  2008-08-07 13:07:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 20:48:23 CST 2008.