urgent:copy previous to new record

[maya]

I have a form where the user fills it up and saves. Now certain data from the previous record will be the same with the new record being added. How do i copy the previous data into the new record on the form so that the user do not need to enter the same data again but just need to change a few fields and the rest will be the same. Pls help..Thanks. I dont want to have a search option for this.

 

[Mile-O]

If you are using a form that doesn't close in between adding data (i.e. date entry form) then you could dimension a from level variable for each thing that stays the same - storing them in the form's BeforeUpdate() event.

Then, on the form's current event, you can use the syntax:

If Me.NewRecord Then
   ' fill controls with variable values
End If

 

[Oldsoftboss]

Try here for starters
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=38751
HTH
Dave

 

[rhomer]

Your users simply have to hit ctrl "(control quote). That will copy whatever is in that field from the previous record.