title: access 2010 with linked sql tables
body: <p>I have a split form view with data coming from linked sql server (2008).</p>
  
  <p>How do I go about updating the record?</p>
  
  <p>Currently, it will not let me change anything in the text boxes i assume this is because the data is coming from linked tables?!</p>
  
  <p>In order to update do i have to create command and coonn objects and program it in the usual vb manner?</p>
  
  <p>And if so, what is the syntax for referencing the linked tables when creating the update query?</p>
  
  <p>On my split form I dropped a button on there and I can see options to make it run macro, run code, etc etc, which one is suitable?</p>
  
  <p>many thanks,</p>
  
  <p>KS</p>