title: Inserting values into previously null fields, locking them
body: <p>I'm working in MS Access 2013 and I want to write some VBA code for a button I made on a form. I want the code to do 2 things: insert values I designate into null fields and lock all fields in the form.</p>
  
  <p>acCmdFreezeColumn doesn't seem appropriate since it doesn't refer to the form. My current thought is to use this framework:</p>
  
  <pre><code>Sub buttonLockForm1_Click()
  
  Dim intResponse As Integer
  
  intResponse = MsgBox( _
      Prompt:="Are you sure you want to lock the form?", _
      Buttons:=vbYesNo + vbQuestion + vbDefaultButton2, _
      Title:="Lock the Form?")
  
  If intResponse = vbYes Then
   ...
   ...
  
  Else: If intResponse = vbNo Then Exit Sub
  
  End If
  
  End Sub
  </code></pre>
  
  <p>Any help you can provide would be greatly appreciated!</p>