I don't understand what you mean by "the form of the students"; however, the
idea of updating a field by 1 given certain criteria should work.
You will need a table and a field to store the last time you did the update
so that you know whether or not it is due (you may not have been there on
9/11 for the update to run). In the Open event of your startup form check
this stored date and compare it to the current date. If the next 9/11 has
passed, run an update query on the field that you want to increment by 1
then update the 9/11 field to indicate that the update was made.
--
Wayne Morgan
Microsoft Access MVP
Adamos H. said:
I have a school library, and I have a form where it displays the form of
the students. I want the form of the students to auto-update to +1 every
9/11 (m/dd) of each year, and if its not to much of a hassle, when they go
to number 8, to notify me. What is essential though is the +1. Thank you in
advance.
