Method to Reuse past Values for New Date?

[Heatshiver]

I have a form that is basically general information. The information changes maybe once every two or three weeks.

I have a date field with a date picker to choose a past or future date. I have a combobox with all the definitive dates that already have data. And I have a Search button so that a known date can be found quickly.

What I am looking to do is to be able to go to a date that has values already, and save those values as a new date. Anyone have any ideas on how to do this?

[June7]

Probably require running an SQL INSERT SELECT action. Review this http://msdn.microsoft.com/en-us/library/ms188263.aspx

[Heatshiver]

From what the article states it seems that I would need to use a SELECT subquery to add data to more than one row, but I believe this would be for only new rows? I'm not very strong with SQL so I'm still puzzled as to how this would allow someone to save those values to a new date...

BTW, half the stuff I look up on the net pops up with your posts!

[June7]

The INSERT SELECT would add one or more rows depending on the criteria of the SELECT subquery. If the criteria filters data so that only one unique record is selected then only one record will be created.

Only Half!

[Heatshiver]

I think I understand how this could work - in terms of how to insert information into a table with SQL - but I am not getting how this will help me tell Access to take the previous data values supplied by a specific date, and add them to a different date specified by the user.

Maybe VBA could help?