Report as Letter

[blue_echo]

I am trying to create a letter to a customer by using reports.

I've added a button to my form and when the report loads it's preloaded with my generic letter and customer related fields but it also pulls up every record instead of the current record I'm on. I want to be able to pull up the customer in my form, click a button to generate the letter, and print just that customer's letter, not the whole table.

[ranman256]

open the report on just the 1 record...
docmd.openreport "myreport",,"[id]=" & txtBoxID