Default previous value

J

Juanjo

I found no satisfactory answer so far to the following problem:
Is there a simple way of entering a record in a form with repeated values
for all the variables as the previous record? This would make data entry
much easier for our research project.
Thanks in advance
 
D

Douglas J Steele

In the AfterInsert event of the form, you could set the DefaultValues for
the various text boxes to the value that's currently in them:

Private Sub Form_AfterInsert

Me.txtField1.DefaultValue = Chr$(34) & Me.txtField1 & Chr$(34)
Me.txtField2.DefaultValue = Chr$(34) & Me.txtField2 & Chr$(34)
Me.txtField3.DefaultValue = Chr$(34) & Me.txtField3 & Chr$(34)

End Sub

However, I have to question your need for this capability. Having multiple
rows with the same value seems very unusual. Are you sure you've normalized
the database properly?
 
K

Keith Wilby

Juanjo said:
I found no satisfactory answer so far to the following problem:
Is there a simple way of entering a record in a form with repeated values
for all the variables as the previous record? This would make data entry
much easier for our research project.
Thanks in advance
Click to expand...

No *simple* way that I'm aware of, I think you'd have to open the recordset
in code and read the contents of the last record to apply them as default
values. Could be messy if you have a lot of fields.

Keith.
www.keithwilby.com
 
Top