after apply filter show blank form.How to detect 0 records??

  • Thread starter Thread starter whatever
  • Start date Start date
W

whatever

hi

I Have a form , and the user goes to filter by form and then
apply filter. When no rows are returned a blank form is displayed
how do I detect this and display a message 'no rows found'?

mike
 
Mike,

I would like to say add a piece of line to your code...
DCount("SomeField","SomeTable") < 0 Then MsgBox Esle run your filter but you
didn't post any code. Perhaps that little tidbit I posted is enough to get
you started?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Thanks i know about dcount...

however we are using filter by form button on a toolbar..when the user
hits the apply the filter by form
no rows returned (a blank form is displayed) ...I suppose I'm asking
what access event do you use to trap this?

On Current dosen't get triggered - as there is no record - what event
can you use to put this magical code?

note, we're using filter by form ..

mike
 
Back
Top