"FindRecord" Error Trapping

[Tony C]

Greetings

I am using the "FindRecord" method in VB for an Access
2000 Application to search certain fields. What I'm
looking for is how do I display a message box WHEN THE
SEARCH FAILS. At the moment the VB Code either finds a
record or on failure it does nothing.

 

[Alex Dybenko]

you have to do this in other way:
(pseudo code)

run .FindFirst method on form's recordsetclone
if .nomatch
msgbox "SEARCH FAILS"
else
'position record
form.bookmark=recordsetclone.bookmark

HTH