title: Microsoft Access Report Events vba
body: <p>Microsoft Access Report.open Event.  I have the following code running when I open a pdf report </p>
  
  <pre><code>Private Sub Report_open(Cancel As Integer)
  
  Me.Filter = "Account_id in(102) And [Level 3] ='Other')"
  
  Me.FilterOn = True
  
  End Sub
  </code></pre>
  
  <p>I changed this code to</p>
  
  <pre><code>Private Sub Report_open(Cancel As Integer)
  
  Me.Filter = "Account_id in(102) And [Level 3] in('Equityarb','Other')"
  
  Me.FilterOn = True
  
  End Sub
  </code></pre>
  
  <p>and tested it and it worked   and saved and got out of report  Upon opening the report  the CHANGES were not in effect  .  Cant get the change to save</p>