Creating a Report

[James]

Hi I would like to do the below as I have ben told that I
could do this in the autoexec macro on opening my database
in a report. but I only want this to come up when there
are records to be displayed.

Many Thanks

James

-----------------------------------------------------------

Hello I would like an MSGBOX to pop up on the switchboard
whn a database is opened. I would like it to have a MSGBOX
to say that the following ID is up for review on (DATE
HERE).

I would like the follwoing on each record which comes
up... So for example if the review date is in a weeks time
then it comes up with:

The follwoing Case (Case Number here) is up for renewal in
one week (Date Here).

The same for the day before and the day its up for renewal.

Also could I add the time aswell for like a meeting date
for the review?

Many Thanks

James