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