title: MS Access Form events, VBA
body: <p>I have 3 fields in an access form. </p>
  
  <ul>
  <li>Field 1 - is a text field pre-populated with some data. There are no null records</li>
  <li>Field 2 - is a text field pre-populated with some data. It can either have a value or be null.</li>
  <li>Field 3 - Is a text field. The user will enter information into the field.</li>
  </ul>
  
  <p>There is a rule. If there is a null value in field 2, then field 3 will equal the value from field 1 and so I want it to automatically populate field 3 from field 1. if the value is not null, then the user will populate the field record manually.</p>
  
  <p>I have set up a form load event to:</p>
  
  <pre><code>If Me.field2 = "" Then
     Me.field3 = Me.field1
  </code></pre>
  
  <p>The problem I am having is, the user may want to change the pre-populated value of field 1 and if the corresponding field 2 record is blank, I want field 3 to be updated with the same value the user changed in field 1. I don't want to have to reload the form all the time for this update to occur. I've tried the above syntax in a After_Update event and a change event, but it's not updating.</p>
  
  <p>Can anyone suggest what I am doing wrong?</p>
  
  <p>Thanks,
  Mike</p>