Mail Merge/Form Letter Issue

[Anthony]

I created a form letter in access that pulls customer information that was
entered into a form. After I have entered the information into the form, I
click a command button to preview the report(letter) & it works fine. But
when I go to add another record & go to preview the report, it pulls info
from the original record. Any suggestions?

 

[Jeff Boyce]

Anthony

"... pulls ... information ... [from] ... a form..."

While this is possible to do in Access, it is a much commoner approach to
have a form display data that is saved in a table. Thus, a form letter or
other "report" pulls data from the table, not the form.

What is the code behind that command button? I'm guessing it sends the ID
of the record on display in the form to the report, but perhaps always sends
the same ID?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP