Repeating Subform Data

[CMooreJr]

Hey everyone! I have a subform that holds the following info.

SKU
Description
NetCost
MSRP
Available
UnitsSold
RetailSold
CostSold
InventoryonHand
WeeksonHand

Now, this data is WEEKLY from a vendor for a particular retail company. For instance, for the week of 1/1/2004 to 1/7/2004 it may look like this...

SKU Description NetCost MSRP Available...etc...
123 aaaaaaa $25.00 $35.00 250
234 bbbbbbb $12.00 $34.99 100

Now, when the client starts a new record for week 2 (1/8/2004-1/15/2004) they want the above info to AUTOMATICALLY populate the subform. The problem is the NetCost, MSRP, etc may change for that week, so it needs to be its own record...IT CANNOT AFFECT THE PREVIOUS RECORD!!!

The Best way I can see if it is possible to write code or a macro to SELECT ALL from the subform and COPY. Then when they open the new record, they can simply click on a PASTE button and it will put that data in the new record. Then they can change what they want without affecting the previous data...can this be done with SendKeys? Any help would be greatly appreciated!!!!

 

[grtammi]

CMooreJr:

From your post, you say that the users cannot change the data - in this case, I would then populate last week's data into a list box control and leave the subform the way that it is ... or, alternatively, you could create 2 subforms on your form - one for data entry (add/edit/delete properties set to True), and the other one strictly for viewing the previous week's data (add/edit/delete properties set to False).

HTH


Greg Tammi, IT Design & Consultation
Work:

http://www.atsbell.com

Home:

http://members.shaw.ca/gregandliz

 

[CMooreJr]

Hey grtammi! Thanks for your input! Basically, what the client wants to avoid is having to type the exact same information for each week. Although there may be some changes, (Cost, availablilty, etc.) the rest will stay the same. Say if they are inputting week2, I dont want the week1 data to be modified, because that would throw off all yearly reports. So it needs to be an entirely new record.

I really dont see a way around having to type the information in again unless there is a way to duplicate the previous weeks data into the new weeks data..and I'm not sure how to do that...suggestions?