title: Compile Error :Method or data member not found
body: <p>I'm basically following this dude on this Youtube Video to create an stock in/out button for my warehouse project. However, his example differs from mine because he is using table to validate the source properties whereas I use Query to validate the source.
  However, by the time I apply for this code toward my button form. The system initiates an error telling me that Method or Data member not found
  What cause this problem and how do i resolve it ?</p>
  <p>Here is the code</p>
  <pre><code>     Private Sub Command16_Click()
          Dim db As DAO.Database
         Dim rst As DAO.Database
         Set db = CurrentDb
  
  Set rst = db.OpenRecordset(&quot;Select dbo_PRODUCT.QUANTITY from DonHang where IDDH=&quot; &amp; Me.IDDH)
  With rst
      .Edit(By the time i press debug,this line filter for some reason)
      !dbo_PRODUCT_QUANTITY = !dbo_PRODUCT.QUANTITY - Nz(Me.QuantityBox, 0)
      .Update
   
  End With
  Me.dbo2.Requery
  
  End Sub
  </code></pre>