title: Filling table fields with value from textbox in Access
body: <p>I'm trying to fill table fields in Access 2013 with a value from a Combobox that is located on a form.<br>
  But i'm not receiving any errors and nothing happens when the code is executed.<br>
  I don't have the exact code i'm using but here is something very similar i found from a website:</p>
  
  <pre><code>   Dim d As Database
     Dim r As Recordset
     Dim Price, Qty, Total As Field
     Set d = CurrentDB()
     Set r = d.OpenRecordset("Table")
     Set Price= r.Fields("Price")
     Set Qty= r.Fields("Quantity")
     Set Total= r.Fields("Total")
     While Not r.EOF
        r.Edit
        Total=Price*Qty
        r.Update
        r.MoveNext
     Wend
     r.Close 
  </code></pre>
  
  <p>I didn't use while not loop in my code but the rest of it is pretty similar.<br>
  After searching i thought adding MS DAO as reference would help but nothing changed.<br>
  My problem is that nothing happens when i execute the code, i even tried to remove the loop and make it only change a value but still nothing.</p>