Repeat Values in New Records

[Jan]

I am trying to have certain fields in my form repeat the
data entered in the first record - until a new
value is entered - but I've been unsuccessful!
Several fields use the same data for perhaps 20
records in certain fields; other fields are updated
every time. If someone could point me to the right
way to do this, I would appreciate the help.

Jan

 

[John Vinson]

I am trying to have certain fields in my form repeat the
data entered in the first record - until a new
value is entered - but I've been unsuccessful!
Several fields use the same data for perhaps 20
records in certain fields; other fields are updated
every time. If someone could point me to the right
way to do this, I would appreciate the help.

Jan

You can set the DefaultValue property of a control in the Form's
AfterUpdate event:

Me!txtX.DefaultValue = Chr(34) & Me!txtX & Chr(34)

You need the quotes, since a Default property must be a string.

 

[Guest]

-----Original Message-----


You can set the DefaultValue property of a control in the Form's
AfterUpdate event:

Me!txtX.DefaultValue = Chr(34) & Me!txtX & Chr(34)

You need the quotes, since a Default property must be a string.



.

Thank You very much! It works wonderfully well. I
appreciate your help..

Jan