Autofill value from previous record

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

In Office 2000, I want to use the last value entered for certain textboxes
when creating a new record on the same form. For example: When I Tab to a
Textbox with a date value, I want it to autofill with the date I just
entered on the previous record in that particular Textbox (not the current
date although it might be). Thanks for any suggestions.
 
Put it in the after update of the text box. After you
enter the first record, every record will be the same
until you close the form.


Me![txtYourFieldName].DefaultValue = """" & Me!
[txtYourFieldName].Value & """"

Chris
 
Thank you Chris, I appreciate your help!

Chris said:
Put it in the after update of the text box. After you
enter the first record, every record will be the same
until you close the form.


Me![txtYourFieldName].DefaultValue = """" & Me!
[txtYourFieldName].Value & """"

Chris
-----Original Message-----
In Office 2000, I want to use the last value entered for certain textboxes
when creating a new record on the same form. For example: When I Tab to a
Textbox with a date value, I want it to autofill with the date I just
entered on the previous record in that particular Textbox (not the current
date although it might be). Thanks for any suggestions.



.
Click to expand...
Click to expand...
 
Back
Top