I have a form that I would like to print one record from but when I put a button on the form to open a report to print, all records show up.  Using access 2013. How can I print just one record. (on the form I select the record I want from combobox, a client from Client table identified by ClientID autonumber field)

---

Reply from Alex Hedley:

See this tip.

Create a Query and have a criteria of a Field on a Form, therefore the record source of the Report becomes only one record and can't then print more.