Help with clearing combo boxes...

[Tyler D via AccessMonster.com]

Hi,

I update values in three combo boxes in a form on a monthly basis. I'd like
to be able to clear all the "old" values prior to entering the new ones each
month. I want to do this without deleting records.

(I do this because I use the data for reports on a monthly basis, and then
the information needs to be updated the next month for new reports....)

Could you offer a suggestion?

Thanks. I tried my best to search the existing threads, but couldn't find
anything that would help...

Tyler

 

[Chris]

The simplest suggestion I would see is to - if you really want to clean out
all records - put all "old" data into a new table.
If you need to, you can set up a cron job to do this every month, instead of
doing itmanually
Alternative #3: when doing monthly reports, filter only for records of that
month (provided you have a field in which you record the date the entry)

HTH

Chris

 

[Tyler D via AccessMonster.com]

I think I need to clarify my self a bit more. There are 15 fields within
each of the 100 records that need to be cleaned out every month. But, I
don't want to delete the records themselves. I could imagine myself manually
deleting the data in each of these 15 fields for each record, but imagine
that this would be a waste of time each month... I'm trying to figure out how
to do it with a click of a button.

The simplest suggestion I would see is to - if you really want to clean out
all records - put all "old" data into a new table.
If you need to, you can set up a cron job to do this every month, instead of
doing itmanually
Alternative #3: when doing monthly reports, filter only for records of that
month (provided you have a field in which you record the date the entry)

HTH

Chris

Hi,

[quoted text clipped - 11 lines]

Tyler