Forms

[sarah2311]

if i am entering duplicate data for some fields - is there a way to pull the data from the last entry rather than re-typing each field - much the way excel will offer an existing entry if the text appears to be the same?

 

[dgm]

In a Continuous form?

 

[sarah2311]

yes -

 

[dgm]

ok, I was asked to do something like this and this is the only way i could think of doing it.

Private Sub Form_AfterInsert()
    If Not IsNull(Me!myField) Then
        Me!myField.DefaultValue = me!myField
    End If
End Sub

So u basically change the default value for the field to the last value entered.
It works for me, but i'm only using it on two fields.
If you want to copy lots of fields maybe a copy/dupicate button that copies all the required fields to a new record?

 

[sarah2311]

all set - thanks