Data Entry Form - Keep Text Box Value for Next Record?

[Jason Gyetko]

I have a data entry form that will use much of the same data for each record
with only one key field changing with each record. When the form comes up
blank, all data will be enter in the text boxes. When the first record is
finished and the database has been updated, instead of all fields getting
blanked out again, I want to keep the data that was entered in the first
record for all but that one key field. This way, I can input the new value
for that one key field, then keep or change any of the data in the other
fields. How do I carry-over data entered in a text box from the first
record to the second record? Any suggestions would be greatly appreciated.
Thanks.

 

[Ken Snell]

Use the AfterUpdate event of each textbox to change the Default Value of
that textbox:

Private Sub txtBoxName_AfterUpdate()
Me.txtBoxName.DefaultValue = """" & Me.txtBoxName.Value & """"
End Sub

 

[Jason Gyetko]

Thanks for the help.

Use the AfterUpdate event of each textbox to change the Default Value of
that textbox:

Private Sub txtBoxName_AfterUpdate()
Me.txtBoxName.DefaultValue = """" & Me.txtBoxName.Value & """"
End Sub