title: What would a macro look like that would save a PDF of a report for each record in a db (in access)?
body: <p>I'm going to be specific as possible but i apologize if my question comes off as confusing upfront...</p>
  
  <p>In my access db I have 5 Tables that are related through 'RefNum' which is an auto number, and the range of 'RefNum's are 1-2694 (or 2694 records). I created a report that is two pages. When I create a form to print the report it creates one large PDF that is 5388 pages (2 pages for each record). What I WANT it to do is create a PDF of the report for each record, so each file would be a two page report for each record. </p>
  
  <p>While creating each file I want it to rename the file to one its respected attributes.</p>
  
  <p>Example: each PDF file would be re-named to --> StudentID.Term</p>
  
  <p>So I assumed that I could do this by attaching a macro to the button, but due to my lack of experience I am lost.</p>
  
  <p>Could some one help me out with this macro?</p>