No records found error message

[Niko]

Hello everyone, How can i add code where it will pop up a message box " No records found! Check again!" when user key in a PO number which is not saved in the record.
Thank you !

[June7]

Could prevent the error by using a combobox that only offers valid PO numbers to select and set the combobox LimitToList property to Yes.

Otherwise, use DLookup() or DCount() domain aggregate function:

If DCount("*", "MXDPO", "[PO Number]='" & Me.txtKeywords & "'") > 0 Then
MsgBox "No records found! Check again!"
Else
...
End If

[Niko]

Could prevent the error by using a combobox that only offers valid PO numbers to select and set the combobox LimitToList property to Yes.

Otherwise, use DLookup() or DCount() domain aggregate function:

If DCount("*", "MXDPO", "[PO Number]='" & Me.txtKeywords & "'") > 0 Then
MsgBox "No records found! Check again!"
Else
...
End If

Hi, can this code work if my search input is a string? such as ABC17/123?

[CJ_London]

cross posted and solution found here

https://www.access-programmers.co.uk...=1#post1550245

[June7]

The example given is for a string value.