assigning values to fields

[DeborahP]

Is there a way when entering data that you can pre-populate fields with the data from the previous record? such as date, same type of load etc.

I know you can use Ctrl+' but I want to try and save some key strokes.

 

[liddlem]

Hi DeborahP
I think that you would need to create public variables for each of the field that you want to carry forward. Then before leaving the record, assign the value of the field to the VAR accordingly. (Im not sure what event is triggered when leaving a record)

In the "On_current" event, you could simply assign the VAR value(s) to the appropriate field(s).

I would be cautious of doing this unless you are 1000% sure that you ALWAYS want to update the data when moving to the next record.

 

[ShaneMan]

Is there a way when entering data that you can pre-populate fields with the data from the previous record? such as date, same type of load etc.

I know you can use Ctrl+' but I want to try and save some key strokes.

Hey Deborah,

Follow this link: http://www.mvps.org/access/forms/frm0012.htm and see if might be of some help with what you are trying to accomplish.

HTH,
Shane