Running a procedure automatically

[billheath]

I have a table which shows Price for a commodity, each day. I go to the commodity form, enter the new price and date and move on to the next commodity's form.
I need to add the information automatically to another table which shows all commodities and prices for every day for a month. This information is then passed to the departments on a monthly basis.
I have a module which passes the information to the second table based on clicking the add button on each form. It would be easier and less chance of mistakes to do it automatically as I advance from form to form. Is there an event generated when moving between forms? I tried form:LostFocus but it didn't work. Any help would be appreciated.
Yes, I can do it on a report but having it readilly available for anyone is more benificial and it is always saved.
Thanks, Bill

 

[dhookom]

billheath,
Would you mind sharing your significant table and field names?
When you state "move on to the next commodity's form" it suggests you have designed different forms for different commodities.

Duane
Hook'D on Access
MS Access MVP

 

[billheath]

There is only one form. I was referring to moving from one record to the next. What I need is an event that triggers whenever i leave one record and move onto the next.I don't mind sharing the table or field names. The only pertinent ones are the Commodity IE; [ST_Name], the date [Date_Cur} and the price [Cur_Val]. The Daily form is simply [frmDaily_Rec]. The final table is [tblTally]. simply, it looks like:
Date Atax Brx bxx cim
8/5/2012 22.533 19.2556 4.005 6.22
8/6/2012 22.566 19.023 3.966 6.322

Thanks, I hope this makes sense.

 

[dhookom]

On a form, the On Current event is fired every time you open or move to a new record.

Duane
Hook'D on Access
MS Access MVP