"FindRecord" Error Trapping

  • Thread starter Thread starter Tony C
  • Start date Start date
T

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.
 
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
 
Back
Top