I'm trying to display Reminder Notice forms when a user opens their Access 2007 database via the autoexec() function.
I have a table that holds Reminder Notices - some in an Open status and othes in a Closed status
I have a query that selects the open Reminder Notice records where the Reminder Notice Date equals the current system date - maybe say 4 or 5 records selected.
I then walk throught this query and write a single record to a temporaty table which in turn is the record source of the Reminder Notice form I wish to display.
After displaying the Reminder Notice form - where the user has the option to basically ignore the form (Remind me later) or to flag that the Reminder Notice is to be closed.
After clicking on the "Remind Me Later" or "Close" button (which basically executes some On-Click event logic it then closes the Reminder Notice form) the logic returns to the next statement after the Open form statement and retrieves the next Reminder Notice record and so on until all the open Reminder Notices have been processed.
That's the logic but the reality is that it only displays the last Reminder Notice
I've walked through the logic in debug mode and it displays a Reminder Notice Form but then continues on immediately to read the next Reminder Notice record without stopping to allow the user to read the Reminder Notice or to take what ever action they need to take . It only stops to display the Reminder Notice form after the last Reminder Notice record has been processed.
How can I get the system to stop after displaying a Reminder Notice form before continuing on to the next Reminder Notice record?
Many thanks in advance for you help/suggestions