title: Compile error: method or data member not found
body: <p>When I try to compile, I have been getting this error saying "Method or data member not found".</p>
  
  <p>This is the code:</p>
  
  <pre><code>Set db = CurrentDb
  Set rec = db.OpenRecordset("Select * from SuppliersT")
  
  rec.AddNew
  rec("SupplierName") = Me.SupplierAddNameTxt
  rec("Address") = Me.SupplierAddAddressTxt
  rec("City") = Me.SupplierAddCityTxt
  rec("ProvinceState") = Me.SupplierAddProvinceStateTxt
  rec("PostalZip") = Me.SupplierAddPostalZipTxt
  rec("Phone") = Me.SupplierAddPhoneTxt
  rec("Fax") = Me.SupplierAddFaxTxt
  rec("Email") = Me.SupplierAddEmailTxt
  rec("Notes") = Me.SupplierAddNotesTxT
  rec.Update
  </code></pre>
  
  <p>It highlights the Me.SupplierAddNameTxt in </p>
  
  <p>rec("SupplierName") = Me.SupplierAddNameTxt</p>
  
  <p>I have a textbox named SupplierAddNameTxt on the form the button is located on, and that's why I am trying to set that up to. Not sure why it's doing this. Help would be much appreciated!</p>