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

[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

 

[Gina Whipp]

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

 

[whatever]

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

 

[Gina Whipp]

Mike,

The only way I ever saw is... http://support.microsoft.com/kb/210037 I
have never used this but it looks like what you are looking for.

--
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