Newbie Needing some Help. TY

[joe90]

Hi,

I am having some trouble to say the least trying to establish how I overcome this problem.

I have 2 fields in my table. StartFigure and EndFigure.
In my form I have StartFigureValue number box and EndFigureValue number box.
What I am trying to do is Autofill the StartFigure new record with the previous records EndFigure.

I want to be able to open the form and have the last EndFigure record to be displayed in the StartFigure number box, and be entered into the table as the new StartFigure for that record!

Hope this makes sense, please help.

Joe

 

[Alisa]

In the afterupdate event of your endfigure box, you could put the value into the startfigure box for the next record.