Want to print ONE record in a form - Access 2007

[davejefferson]

WTF is up when printing a form (record) in Access 2007??????? When I go to print preview the form displays (and wants to print) every record!!!! How do i get only ONE record to display and print.. HELP

[pbaldy]

It will print every record in its record source. Most of us only print reports, as you have more control that way. Forms for interacting with data, reports for presenting it. I often use this method to restrict a form or report:

http://www.baldyweb.com/wherecondition.htm