Recently I have had some troubles while using DLOOKUP. I was using DLOOKUP to look a value in a table in a on click event, however when the event is run it gave me the "type criteria mismatch" and it won't work regarles of how or how many my "" or '' are arrengent, DLOOKUP won't work until I set all the values of the table to the same kind: all text, all numbers, but no mixes. I have use it before in tables where the values are not the same kind and never encountered a problem until I began using Access 2010.  Is this a behavior or configuration I can change on Access 2010 or is a legitime error?

---

Reply from Richard Rost:

I've never seen this behavior before, but it's impossible for me to tell you what's wrong without seeing your database.