DoCmd.FindRecord Question 1

[numbat]

I need a routine that finds a record typed into a text box. My question is how do you notify the user if the record was not found. DoCmd doesn't seem to return an error when it doesn't find a record. Does anyone have any tips?

 

[PHV]

Take a look at the DLookUp function:
If IsNull(DLookUp("ColumnName","TableName","Criteria")) Then
MsgBox "Not Found"
Me.TextBox1.SetFocus
End If

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884