Trap Errors

[chris17]

I have a search text box, how can i create a message box to tell the user that entries in the text box does not match any record in the table.

[orange]

I'd suggest looking at the DCount function.
If Dcount(..) = 0 Then
Msgbox "No such record"
else
'''''whatever you want to do with found records''''
end if
see http://www.techonthenet.com/access/f...ain/dcount.php

If you are using a search/find function, you could use the NoMatch


from allen browne's site

  rs.FindFirst "City = ""New York"""  
If Not rs.NoMatch Then        
 'It's okay to keep processing.
End If

[chris17]

what should be in (..) in the Dcount

[orange]

You're going to have to tell us more of the table , the text box and the search.

I have a search text box, how can i create a message box to tell the user that entries in the text box does not match any record in the table.

Did you look at the examples at
http://www.techonthenet.com/access/f...ain/dcount.php