Display "No records found" on Access Form (1 Viewer)

L

luzz

Registered User.

Local time

Yesterday, 19:23

Joined

Aug 23, 2017

Messages

346

• Oct 16, 2017

• #1

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

  10 KB · Views: 219

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 10:23

Joined

May 7, 2009

Messages

19,237

• Oct 16, 2017

• #2

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

 

C

CJ_London

Super Moderator

Staff member

Local time

Today, 03:23

Joined

Feb 19, 2013

Messages

16,610

• Oct 16, 2017

• #3

cross posted here with answers http://www.accessforums.net/showthread.php?t=68608

@luzz - please read this link about the etiquette of cross posting
http://www.excelguru.ca/content.php?184

 

L

luzz

Registered User.

Local time

Yesterday, 19:23

Joined

Aug 23, 2017

Messages

346

• Oct 16, 2017

• #4

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~

 

L

luzz

Registered User.

Local time

Yesterday, 19:23

Joined

Aug 23, 2017

Messages

346

• Oct 16, 2017

• #5

CJ_London said:

cross posted here with answers http://www.accessforums.net/showthread.php?t=68608

@luzz - please read this link about the etiquette of cross posting
http://www.excelguru.ca/content.php?184

Click to expand...

Opps, I am sorry!