Syntax for Record not found on Select

[DahMurf]

I've set up a Select statement to grab a specific record. I need to test if the record is not found. Can someone give me the syntax, I can't seem to find it.
Thanks!

 

[smedvid]

... Use a Record Set.. .check Record Count
'Check Expired Passwords
Set rs = ThisDB.OpenRecordset("qry_USER_PW",
dbOpenSnapshot)
rs.movefirst
If rs.RecordCount <> 0 Then
'Get List of Who to E-Mail To

Steve Medvid
&quot;IT Consultant & Web Master&quot;
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[DahMurf]

Thanks so much, that did the trick! I'm a COBOL nerd so I'm still learning the SOP's of VBA. I know what I want to do, just can't always figure out how to code it correctly. My installed help screens are incomplete so I tend to stumble a bit!