With something of a better understanding of your goals and knowing you're
looking for a simple solution without having to write a bunch of code, here's
what I would suggest. Create a table (tblRecapDate) with one date/time field
called RecapDate. Enter the current recap date in the that field. Close the
table. Open your form in desgin view and in the default value field for the
Recap Date control enter =Dlookup("[RecapDate]","tblRecapDate"). Now
whenever you enter a new invoice it will have the current RecapDate value in
the Recap Date field. You will have to change the value of the RecapDate
field in tblRecapDate every two weeks or whenever it changes, but that may be
easier for you to maintain than writing procedures to automate the process.
Hope this helps.