Autofill value from previous record

[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.

 

[Chris]

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

 

[Tom]

Thank you Chris, I appreciate your help!

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.



.