autopopulating field

[shannon]

Does anyone know a good way to automatically populate one
field with a certain value based on the value entered into
another field via form?

Thanks much.
Shannon

 

[Duane Hookom]

I think lots of us know how to do this. You can use the after update event
of "another field" to set the value of "one field".
Sometimes this suggests storing calculated values which isn't generally
recommended.

 

[shannon]

Thanks...I have set the afterupdate event to populate my
field. I have another issue now...can you answer this
question? The field I am autopopulating is on a subform in
continuous view. I have the field set to default to the
Year field on the main form. (User enters year after
opening form) Problem is that only the 2nd record on the
subform contains default value. Year field on 1st
subrecord is left blank. How can I get the 1st record to
recognize the year the user entered??

Thanks again.

 

[Duane Hookom]

Code like
Me.sfrmA.Form!txtYear = Me.txtYear