Message Box...??

[Fulcrum]

Hi,
I,m having problems creating a message box that will run when access is started. I have a query that shows items due for calibration with the critera >date()+31 applied to the duedate field. I want to check for new items due for calibration when access first opens and display a message box if there are any with the options to just acknowledge the message or show the items due for calibration.
the duedate query find all items within 31 days of there due date so I would want the message box to only show new items as they enter this time period and not the same ones for 31 days.
Any help would be very welcome.
Thanks to those who sorted out my last prolem.

 

[DBL]

How about a Prompted checkbox in your table and when the file comes into the date bracket and shows on the query you could run an update query to tick the prompt boxes for those files that have been shown. You then could change your existing query to only show you files that come within the date range and haven't already been prompted.

 

[Fulcrum]

I dont really mind how it's done as long as it prompts at startup and only looks for new items that fall into the 31 day time period,
after they have been acknowledged it only prompts again when a another new item enters this period.

Thanks........