title: MS Access 2003 - Information from a form output to a text file
body: <p>So I have this form that has tons of text boxes, combo boxes, etc. There is VB in the form's module that check to see if there are duplicates, and then run a few update queries to save the information in to tables. All that works great.</p>
  
  <p>My question is what VB method can I use in this forms module to take information from all these objects (txt, cmb, etc) and output/save it into a text file? </p>
  
  <p>I would just use as an example a form with the following three text boxes:</p>
  
  <pre><code>Text1 - String
  Text2 - Date
  Text3 - True/False
  </code></pre>
  
  <p>I know the vb for adding this to the database tables, but I am looking to be able to save the information in a text file, and then use the SendObject method to allow for these text files to be emailed from the field to the hq, and then placed in a larger db.</p>
  
  <p>The outlook sendobject I think I have a pretty good handle on that portion, just need to figure out how to create a text file with the data in it. Thanks for the help!</p>