You seem to have extra spaces in a few places (substituted below with *)

rstTemp.Filter = "CityDataID='*" & strFilter & "' And Year='*""' And Month='*""'"

Tim
--
Tim Williams
Palo Alto, CA


"greenfalcon" wrote in message
...

Hey everyone, thanks for your help, im in a bind and need a little
help... I am trying to search a database with excel and find out if a
record is blank with recordset.filter... here is my code..


Code:
--------------------
rstTemp.Filter = "CityDataID=' " & strFilter & "' And Year=' ""' And Month=' ""'"
--------------------


Pretty much i want it to find a primary key (CityDataID) and if it does
find it see if the recors for Year and Month are blank. I cant seem to
get this code to work... Any ideas? I would be very grateful

Thanks!


--
greenfalcon
------------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...o&userid=13622
View this thread: http://www.excelforum.com/showthread...hreadid=560347