Question Record field as record in table every month.

[DanJames]

I have a field (Text9) on a form and would like to have the code to be able to add the value of that field to a table once every month. The database wont be opened everyday so it would have to be nearest to a month if not exact?

Any ideas? Thanks, Dan.

 

[AlienRay]

You need to add some code to the On Open event of the form that holds that field. When that form is opened, it needs to look at the maximum value of the date stamp in the target table. If that date is more than a month old, it can add a new record via an Append Query.