Set Default text in a textbox to whats in the previous record

[marcin2k]

I have a contiuous form that works on a table. Basically its used to fill the table. I want to make it so that when a new record is made in the table the default text in it is what was in the previous record. Not sure if it is possible but I hope it is. This would save my people who enter data a hell of a lot of time when things are reptetive.

THanks, Marcin

 

[FancyPrairie]

In the AfterUpdate event of the field, set the default property to the current value.

ctl.DefaultValue = """" & ctl.value &