This is my on no data event and I dont get a second box.
Private Sub Report_NoData(Cancel As Integer)
MsgBox "No data found with the date you entered! Closing report."
Cancel = True
End Sub
Todd
On 2/15/06, eliotchs <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I kind of answered my own question(With a little help for John V's
> sample DB sent to me) Using the On No Data event using a msgbox,
> Which works but after I put up the MsgBox, I get "The OpenReport
> action was canceled" Msgbox, Can this be eliminated?
>
> Thanks
>
>
>
> --- In [email protected], "eliotchs" <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> > I have a form which asks for month(cboMonth) & Year(cboyear).
> > when user chooses a report from a button, it runs that report for
> month
> > and year. The problem is I get a blank reort with "error" in the
> data
> > fields if no data exists. Can I get a messagebox, which state "No
> > data".. before the report runs, if there is no data?
> >
> > Thanks In Advance
> >
> > Joe
> >
>
>
>
>
>
>
> SPONSORED LINKS
> Microsoft access
> database<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA>
> Database
> development
> software<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w>
> Database
> management
> software<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg>
> Database
> software<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg>
> Inventory
> database
> software<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw>
> Membership
> database
> software<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microsoft+access+database&w2=Database+development+software&w3=Database+management+software&w4=Database+software&w5=Inventory+database+software&w6=Membership+database+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "ms_access<http://groups.yahoo.com/group/ms_access>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
