Message when Records are Null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you please tell me how to display a message when a filter returns blank
data i.e. no records?

I'm guessing something like 'If (something) is Null then Msgbox "There are
no records to display'

Thanks
 
Bacornroll,

This is one way:

If Me.FilterOn AND If
IsNull(Dlookup("[Something_ID]","TblSomething",Me.filter)) Then
MgsBox ... etc
ElseIf IsNull(Dlookup("[Something_ID]","TblSomething")) Then
msgBox ... etc
EndIf

Reagrds/JK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form filter combo box choices are Is Null/Is Not Null 13
Recordset.clone record count issue 3
Need combo box to refresh when moving to new record 2017 1
field Null but not Null 9
Not Like - not working in query criteria 2
How to enter a Wildcard or Is Null into a query paramater ? 7
RUNNING TOTALS 5
linking null records 4

Back
Top