Gustav Brock
Gustav at cactus.dk
Fri May 2 13:58:37 CDT 2008
Hi Reuben Couldn't you check for .RecordCount = 0? /gustav >>> reuben at gfconsultants.com 02-05-2008 20:49 >>> I have a query that has three criteria. I am trying to find a record that matches the address and city but not within the same distribution... Street = 'X' and City = 'Y' and ReportDate <> 80301 I know nothing matches this criteria. The recordset returns one blank record. There's problem...I cannot check for EOF because there is one record. I also cannot check for a null value because I keep getting a message about ... Error 3021 eof must be true or the record has been deleted. Requested operation requires a current record. Any suggestions? Reuben Cummings GFC, LLC 812.523.1017