Autofill new record w/data from last record (1 Viewer)

[Amanda003]

I apologize if this has been answered already. I have been searching all day for a solution. :banghead: 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

 

[pbaldy]

One way would be this in the after update event of a control:

http://access.mvps.org/access/forms/frm0012.htm

 

[Amanda003]

I am probably do this all wrong, I kept getting an error.

Do I need to put this exactly how it is right here or do I need to add my information somewhere?

const cQuote=""""
me!Control.DefaultValue = cQuote & me!Control.Value & cQuote

 

[pbaldy]

You need to replace Control with the name of your textbox/whatever.