Ok, my explanation on this one is probably going to be as miserable as all of my others, but here goes...
I have two tables, one table (current) and one (history). As you can guess the current table holds current values, values generated for this month and the history table holds values for all months past (up to 7 years). What I'd like to be able to do is have one control on my data entry form store it's value to the current table (OnLostFocus) and then when a button is clicked, also store that same value in the history table. Catch is, the past values in the history table can't be overwritten, so a new record will be created each time the button is clicked. The keys for the history table are an account name and the date, so ideally I'd like a new record for a new date.
Ok, now to try and clear up all the crap I just spewed out...
The end user types the values into the data entry form, as usual with Access, when they leave that control, the value is update automatically to the recordsource that the control is bound to in the "current" table. A button on that same form will be used to save those values to the "history" table, creating a new record for those values every time the button is pressed.
Anyone have any ideas on how I could do this? I already have everything set up and working with the current table, just need to figure out away to work the history table into it. I'm a beginner at Access, and a nothing at VBA, but if anyone has any suggestions, and can just give a shove in those directions, I'd love to muck around and try and figure it out. So far I've been using VBA to duplicate thos values in a seperate form and then link the controls in that form to the history table, but they aren't creating new records, as I'm sure all of you who know what you're doing have guessed. It's probably best accomplished with just straight VBA right?
hardware
prices 
