Autofill new record w/data from last record

[Amanda003]

I apologize if this has been answered already. I have been searching all day for a solution. This is my first time using Access so a lot of this goes over my head. I'm currently running Access2010.

I have a form that I am using for when people take office supplies and we can generate a cost per department. All of the Tables, Query and Reports are set up already and surprising work.

My form fields are:

Date Created (automatic current date)
Quantity
Item Code (Combo Box that shows Item# and Item Description)
Initials
Department (Combo Box that shows Dept# and Dept Description)
RefCode
Remarks



I am trying to get it to where when I enter a new record it will autofill with all fields expect "Item Code" from the previous record until I change it?

Thank you in advance

[RuralGuy]

Maybe this link will help: http://access.mvps.org/access/forms/frm0012.htm

[Amanda003]

I have tried this code and kept getting errors, I'm sure I'm not entering the information right. Like I said this stuff goes over my head.

[RuralGuy]

Where did you put the code and what errors were you getting?

[Amanda003]

I put it in "After Update" property field. Here is the error:

[RuralGuy]

It looks like you had it in the "BeforeUpdate" event.

[Amanda003]

I apologize, I really have no idea what I'm doing. This is what I have tried to enter.

[RuralGuy]

Actually, that looks pretty good except it should be in the Form's BeforeUpdate event.