I am making an inventory program and I am confused. I have a database named Inventory.mdb. In that DB I have a table for the opening numbers, for the deliveries, sells,close and over/short. What I am doing right now is just using the open table. The inventory is done on a daily basis and I save the values in the txtClose boxes to the open table for the next record. My problem is I want to save all the numbers for each day in the appropriate tables. Right now I am not using a data control, I am doing it in code. Can I just copy the code I have for the open, but select from a different table, or should I use a bunch of data controls? I know this is a confusing question, but that is the best I can explain it.