Copy previous records?

[Aximboy]

How do you copy all previous records of a subform to a new record?

I need to create in inventory database of our laboratory equipment. It should list all equipments we have every 3 months.
I was thinking, I'm going to create the first table for the entry date or the date of the inventory, and the second table which will list all the laboratory equipment.

Since the second table will probably contain the same list as the previous record (the user will just delete if there's a missing equipment or add if there's a new one.) I want the subform to copy all the previous equipment to carry over when I enter a new inventory date.

Thanks in advance!

 

[Andrzejek]

Why would you want to copy the entire record just to say: "Yeah, we still have it"?

You will end up with multiple records with the same information of: Make, Model, Serial Number, Date of Purchase, Office, etc. etc. etc. And the only difference will be Date Of Incentory with "Yes, we had it in January", and "Yes, we had it in April", and so one...

Have fun.

---- Andy

 

[kermit01de]

Think about having one table with all the equipment -> ID, Description, Date of purchase, price, serialno (if applicable), info1, info2 etc.

second table with current stock -> ID, count

third table inventory -> ID, count, date

- query to init count, where you add equipment ID and count = 0 (or take over actual value) to third table
- Form to enter counted values to third table
- function to close inventory -> update counts in second table, update date in third table

... that are just basic thoughts that have to be filled with real life ...



Kind regards
Mirko
--------------------------------------
>>>>>> ... I am sure, some supportissues are a matter of PEBKAC ... <<<<<