:( Thing is....I have a database with multiple tables. One table holds 1.2mm records. I have a report that I would love to use to print details of the record that is being viewed on the form at a particular time. Now..I added a print button to the form, however, whenever I click the print button, it never prints the record I am looking at....it prints the entire population.

How do I get the print button to only print that particular record at that time?

Look up the where argument of the OpenReport Method (or Action). Usually, the wizard builds the print button correctly for you but either you build the button yourself or did not select the correct option.