On No Data Event
in [Form]
|
From: Mike from Moriches on 24 May 2010 09:43 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.
From: Allen Browne on 24 May 2010 10:00 Cancel the form's Open event, e.g.: Private Sub Form_Open(Cancel As Integer) If Me.Recordset.RecordCount = 0 Then Cancel = True MsgBox "Nuffin 2 c here." End if End Sub (Note that checking whether there are records may cause the form's events to trigger in an order different to that published by MS.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Mike from Moriches" <Mike(a)The-Waterways.org> wrote in message news:4bfa828c$0$21869$607ed4bc(a)cv.net... > 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.
From: Mike from Moriches on 24 May 2010 19:16 Thank-you Allen - Your code works perfectly! Mike "Allen Browne" <AllenBrowne(a)SeeSig.Invalid> wrote in message news:uOOX8l0%23KHA.5224(a)TK2MSFTNGP06.phx.gbl... > Cancel the form's Open event, e.g.: > > Private Sub Form_Open(Cancel As Integer) > If Me.Recordset.RecordCount = 0 Then > Cancel = True > MsgBox "Nuffin 2 c here." > End if > End Sub > > (Note that checking whether there are records may cause the form's events > to trigger in an order different to that published by MS.) > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > > "Mike from Moriches" <Mike(a)The-Waterways.org> wrote in message > news:4bfa828c$0$21869$607ed4bc(a)cv.net... >> 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. >
|
Pages: 1 Prev: Changing mask on form Next: Having a difficult time with a lookup |