When a user opens up the database, I want pop-up notices to appear telling them who they need to follow-up on. For instance, there may be 10 people that need to be called or have letters sent to on a given day. I want ten messages to pop up with each person's name and what needs to be done. Then when all have been taken care of and the user has indicated this on the form, the messages will no longer pop up. I'd like to be able to read a specific field on each line of a table until eof using some kind of do-loop. Has anyone done this?

Hey there,

I would accomplish this like this:

Add a 'tasklist' column (as a checkbox) and 'follow up, date' to the appropriate table.
On opening the database, have a splash screen that says relevent info, and when the user clicks the ok button, have the button trigger a report run on the date with un-checked entries. The button should also (optionally) email a copy of the report/print one off, and then open a further form with the checkbox, and as I use in my case, the outcome. Of course, if there are no unchecked items on a day, then the user is free to proceed unhindered.