Repeat Values in New Records

  • Thread starter Thread starter Jan
  • Start date Start date
J

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
 
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
Click to expand...

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



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

Jan
 
Back
Top