View Single Post
  #1  
Old May 24th, 2010, 02:43 PM posted to microsoft.public.access.forms
Mike from Moriches
external usenet poster
 
Posts: 11
Default On No Data Event

Greetings -
Is there a Forms event similar to the On_No_Data event with reports? I
have a small form that builds a filter for a recordset. If I run a
DoCmd.OpenReport I can trigger No Data event when the filter finds no
records. However, if I use a DoCmd.OpenForm with the same filter, a blank
form displays. I would like to prevent the Form from displaying if no
records are found by the filter. What is a good approach to capture the
fact that no records meet the filter criteria? Thanks in advance for any
suggestions,
Mike N.