I am sure this is a simple question, but my brain is currently operating at "sub-simple".
I have a form used to collect data that populates a table. When I enter a value into one field on the form, I need that same data to appear in another field on the same form.
1) Which event will do that: AfterUpdate on the first field ?, or BeforeUpdate on the next field? (or GotFocus. LostFocus, etc???)
2) Can you help me on how that event procedure would be written? This is new for me and I think if I could see an example of how it should be written, that would really help. All I need is to take the entered value from the first field and duplicate it in the second field, so that it doesn't have to be retyped for each record. Then, of course, if/when the data for the second field truly needs to be different, it would be retyped on the form. The event procedure will save keystrokes for the occasion when the value should be the same for both fields. The purpose is to set a default for the second field based on the previous field's entry. Any/all help is greatly appreciated.
I have a form used to collect data that populates a table. When I enter a value into one field on the form, I need that same data to appear in another field on the same form.
1) Which event will do that: AfterUpdate on the first field ?, or BeforeUpdate on the next field? (or GotFocus. LostFocus, etc???)
2) Can you help me on how that event procedure would be written? This is new for me and I think if I could see an example of how it should be written, that would really help. All I need is to take the entered value from the first field and duplicate it in the second field, so that it doesn't have to be retyped for each record. Then, of course, if/when the data for the second field truly needs to be different, it would be retyped on the form. The event procedure will save keystrokes for the occasion when the value should be the same for both fields. The purpose is to set a default for the second field based on the previous field's entry. Any/all help is greatly appreciated.