title: getting syntax error using microsoft access we have built
body: <p>syntax error on the area of code E at the start 6th line</p>
  <pre><code>Private Sub Combo21_AfterUpdate()
   ' Update the row source of the cboProducts combo box
   ' when the user makes a selection in the cboCategories
   ' combo box.
   Dim mybuyprice, myproduct, myunits
  **E   If DLookup(&quot;[Buy Price]&quot;, &quot;GoodsIn_Buy_Price&quot;) = Null Then mybuyprice = &quot;0&quot; Else mybuyprice = DLookup(&quot;[Buy Price]&quot;, &quot;GoodsIn_Buy_Price&quot;)
  Me.Buy_Price = mybuyprice**
  
  If DLookup(&quot;[Product]&quot;, &quot;GoodsIn_Buy_Price&quot;) = Null Then myproduct = &quot;Null&quot; Else myproduct = DLookup(&quot;[Product]&quot;, &quot;GoodsIn_Buy_Price&quot;)
  Me.Product = myproduct
  
  If DLookup(&quot;[Unit of Measure]&quot;, &quot;Product_Unit_Check&quot;) = Null Then myunits = &quot;0&quot; Else myunits = DLookup(&quot;[Unit of Measure]&quot;, &quot;Product_Unit_Check&quot;)
  Me.Unit = myunits
     
  Me.Refresh
  </code></pre>