View Single Post
 
Old 05-31-2017, 08:04 PM
Kluz's Avatar
Kluz Kluz is offline
Sapience.Aquire

Super Moderator
* Expert *
 
Join Date: Oct 2003
Location: Lake Bluff, Ill., U.S.
Posts: 3,444
Default

When you fill a recordset object it defaults to the first record. You can fill the object from a SQL statement limiting it to only the one record where Me.IDnum.Value occurs or an empty record set if it can't be found. The rstPractitioner object has a "RecordCount" property: test for > 0. It also has a filter property if you need to test for several values one at a time and there are the EOF and BOF properties will will both be true for an empty recordset.
__________________
No the other right mouse click
Reply With Quote