I'm experience a lapse in memory here -



Can someone explain how to use ADO to search a database field for a 

specific value -- and if the value is not found, pop a msgbox up. 

(specifically, I'm have a user enter in their client ID, and then I want 

the CODE to check the database to make sure it's valid--so I'm pulling the 

value I want to search for from the text box on that form)



Thanks in advance!

Depending on the direction in which you search, calls to the .Find method of

an ADO recordset object will put the recordset pointer at either .EOF (if

you search forward) or .BOF (if you search backward) if it doesn't find a

record that satisfies the find criteria.



HTH,



-Roy



-----Original Message-----

From: Jon [mailto:jsaam@m...]

Sent: Thursday, August 30, 2001 4:05 PM

To: Access

Subject: [access] ADO help plz!!





I'm experience a lapse in memory here -



Can someone explain how to use ADO to search a database field for a 

specific value -- and if the value is not found, pop a msgbox up. 

(specifically, I'm have a user enter in their client ID, and then I want 

the CODE to check the database to make sure it's valid--so I'm pulling the 

value I want to search for from the text box on that form)



Thanks in advance!