Display "No records found" on Access Form

L

luzz

Registered User.
Local time
Today, 12:37
Joined
Aug 23, 2017
Messages
346
Hi guys, how can i add the code where it will display "No record found,check again" error message when user key in PO number that are not saved in the database?
PO: ABC17/123

Thank you guys!
 

Attachments

  • search.png
    search.png
    10 KB · Views: 275
Tst it first before setting the recordsource:

If dcount("*", "mxd", "mxdpo like '*" & me. TxtKeywords & "*'") =0 then
Msgbox "No record found"
Else
'Set recordsource here
End If
 
arnelgp said:
Tst it first before setting the recordsource:

If dcount("*", "mxd", "mxdpo like '*" & me. TxtKeywords & "*'") =0 then
Msgbox "No record found"
Else
'Set recordsource here
End If
Click to expand...

Thank you! It works~
 
You must log in or register to reply here.

Similar threads

A
Display a list of previous jobs with same serial number on current job form
Replies
13
Views
1,018
andymartin3186
A
C
Checking if records exist
Replies
12
Views
1,275
cheekybuddha
cheekybuddha
S
Solved Getting "No Current Record" on query that previously worked
Replies
6
Views
777
Gasman
Gasman
Papa_Bear1
Getting an error 3825, complaining about multi-valued fields, but none are involved.
2
Replies
25
Views
806
Papa_Bear1
Papa_Bear1
J
Form Not Showing All Records From Table
Replies
4
Views
779
Gasman
Gasman

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom