Speed Data Entry By Pre-populating with previous entry

[Carol Spears via AccessMonster.com]

I'm creating a data entry form. A lot of the entries are the same except
for certain fields. Is there a way to speed data entry by prepopulating
the fields with the previous record??

Thanks,
Carol

 

[Al Camp]

A common method is to use the DefaultValue for those fields you want duped.
Let's say you want 2 fields values on the next new form. (a text and a num)
As you fill out those values, use the AfterUpdate event to set the
DefaultValue of that field to what you just entered.

Private Sub Field1_AfterUpdate() ' Text Field
Field1.DefaultValue = "'" & Field1 & "'"
End Sub

Private Sub Field2_AfterUpdate() 'Num Field
Field2.DefaultValue = Field2
End Sub

Another good point is that these Defaults only apply for that session, any
time you enter new data in any of those 2 fields, the Default changes along
with it.

hth
Al Camp

 

[Carol Spears via AccessMonster.com]

Thank you Al. It's working just fine.

Carol