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

  • Thread starter Thread starter Jason Gyetko
  • Start date Start date
J

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.
 
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
 
Thanks for the help.

Ken Snell said:
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
Click to expand...
 
Back
Top