First of all, thank you very much to Mr. Vinson who came close to the right
solution, but the problem was I don't think I had explained precisely what I
needed.

The problem I have is that I have a database that stores the date of the
next standing order in a date field. When this date is reached i.e. it
matches 'todays date', or if the date is passed, I would like the field to
increase the date stored by one month.
I need this to happen on all records once the form is activated rather than
checking each record individually.
Any more help would be much appreciated.
Again I thank Mr. Vinson for his input, and I hope this has clarified any
misunderstanding in the problem.

It would appear to me that you need to loop through a recordset using a
Update query to update the value if it meets your specifications.

RD


-----------------------------------------------
~~ Message posted from http://www.MSAccessForum.com
~~ View and post usenet messages directly from http://www.MSAccessForum.com