title: copying fields in access by a macro/button on a form
body: <p>Good day</p>
  
  <p>ms-access 2007</p>
  
  <p>I have 2 sub-Datasheet's on my form,
  One display a list of items.
  the other is blank.</p>
  
  <p>Is there a way by placing a button on the form "Copy/Add", it copies the highlighted field to a field in the blank data-sheet.</p>
  
  <p>both field's are of the same type.</p>
  
  <p>Thank you</p>