Hey everyone, thanks for your help, im in a bind and need a littl
help... I am trying to search a database with excel and find out if
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 doe
find it see if the recors for Year and Month are blank. I cant seem t
get this code to work... Any ideas? I would be very grateful

Thanks

--
greenfalco
-----------------------------------------------------------------------
greenfalcon's Profile: http://www.excelforum.com/member.php...fo&userid=1362
View this thread: http://www.excelforum.com/showthread.php?threadid=56034