Populate field from field on previous record

[randolphoralph]

I have a form that allows users to add new records only when they click on a button on the form.



I am trying to get a field named Unique ID to populate with the same information from the previous record that the user entered only when the user pushes the button.

I am not sure where to begin to get this to work.

[pbaldy]

One way:

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

[randolphoralph]

Thanks pbaldy!

[pbaldy]

No problemo!

[DNRTech]

Hi, pbaldy.

I was wondering how I could adapt this solution for the previous entered value to be the default value for each new record with using a control button.

[pbaldy]

I don't understand what you want to do differently. More common than putting this behind a button is probably putting it in the after update event of the control.

[DNRTech]

oh I'm sorry,typo. I meant without a control button. I'll try to put it behind the after update event.

[DNRTech]

I still had trouble using the code in the above link in an after_update event for whatever reason, maybe its a 2007 issue.

I did find another method. To use the previous entry as the default value for a record one can add this code to the default value property of the control. Not sure if this will work for combo boxes, but it seems to work fine for text fields.

=DLast("FieldName","TableName")