Save Field Entries

[gbwiii]

On my form I have numerous fields - just like most forms once you tab thru the last field it saves the data and all the fields clear. What I would like if I could control some of the fields to retain the value in them for the next record. Is there a setting I can use to save the data until the form is closed and then clear once the form is reopened ?



Thanks

[pbaldy]

One way:

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

[gbwiii]

Wow, that was quick, is this for a constant default value ? On my form the value changes for each record. To make it a little clearer I am tracking aircraft post flight write-ups. So what I have found myself doing for the program I created is if the plane comes back with several writeups I am typing some of the same data for each write-up, i.e. plane number, flight number, date, over and over. Will what you gave me work for this senerio ?

Thank You

[pbaldy]

In the after update event of a control, it should carry forward whatever value you enter. Why don't you try it?

[ketbdnetbp]

You can also use a combination of keystrokes, CTRL and ' (Apostrophe) and it will pull the data from the previous record's control and place it into the current record's control. Unfortunately, you would have to repeat the (CTRL & ') keystroke process for each control you wish to duplicate. However, in some cases, it makes sense and saves data input time.

All the best !

Jim

[gbwiii]

I certainly will try this; I have been looking for this solution for a long time. Not sure if I apply this code to each field that I want to retain its value when I move to the next record, do I have to add the name of the field to the code. I am somewhat of a novice but will experiment with it....


Thank You - Greatly Appreciated

[gbwiii]

Thanks - I never heard of that but will start using it !

[pbaldy]

Not sure if I apply this code to each field that I want to retain its value when I move to the next record, do I have to add the name of the field to the code.

This solution you would add to the after update event of each control containing a field you wanted carried forward. You would replace "Control" with the name of your control.

Another solution for multiple controls:

http://allenbrowne.com/ser-24.html

[gbwiii]

One way:

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

I have been trying this and keep getting an error message, can not find the name of my control. I was told that the code that you mentioned below the top portion goes in the declarations of a module. I have never created a module. Does that sound right !
const cQuote="""" 'Thats two quotes me!Control.DefaultValue = cQuote & me!Control.Value & cQuote

[gbwiii]

I got the code to work on all the fields that I want the data to carry forward to the next record, the only strange thing I see is one of my fields is a date field which the control name is Date. When the next record comes up it doesn't display what I typed in the previous record, what it displays in the Date field is 12:00:43 AM, What would cause that ?


Thank you for your time !


George

[ketbdnetbp]

I don't know if this pertains to the problem you're having at the moment but, many experts have indicated that the use of Access reserved or keywords for field, object, or variable names, i.e. "Date", might cause some unexpected and unwanted behavior. You may want to consider changing the name of the "Date" field to something else.

All the best,

Jim

[gbwiii]

Thanks - This code worked for some of the fields on my form and the ones that it didn't I gave up and looked for another solution to carry forward the data to my next record and I found this code that works great. This is with my control names...With this I don't even need a module.

Me![Pilot Last Name].DefaultValue = "'" & Me![Pilot Last Name] & "'"