Data type mismatch in criteria expression

[marnieg]

I have a form with a button that calls an event procedure. I'm trying to check a count of number of records that meet a certain criteria based on the information the user enter into two combo boxes. One is a drop down from one table, data type text. The other is a drop down on a table of valid dates stored in a table. Here is my sql.

intCount = DCount("bau_auto", "BallotUsage", "bau_loc = '" & Me![Combo0] & "' And bau_date = " & Me![Combo4] & "")


I have tried both single quote around combo4 and no single quote but get the same error.

Thanks in advance!

 

[pbaldy]

See if this helps:

http://www.mvps.org/access/general/gen0018.htm

 

[marnieg]

Thanks for the quick reply and helpful link.

Using the # resolved the problem.

This is a great forum for Access!