How Do I Fill A New Record With Data Found In The Previous Record?

[dmills]

I want to autofill the new record that I am working on with data found in a
previous record so that the user does not have to retype the info over and
over...

I already went thru the microsoft help site and created the module with all
the code and went thru the other steps but when placing the text box and
setting the default value to the field ("Company") the only one i wanted to
replace and then trying to use the form... it fills every record...

does anyone know how to accomplish this for one field selection at a time?

 

[Douglas J. Steele]

Default values shouldn't fill every record: they should only provide a value
when you create a new row.


Let's see the code you're using.

 

[Damon Heron]

If you just want one field, the CompanyName??, then in the afterupdate event
of the textbox for Company,

Private Sub Company_AfterUpdate()
Company.DefaultValue = " ' " & [Company] & " ' "
End Sub

Damon