creating a letter which has name and project title to be filled automatically.

[jinalpatel]

Hello,

I am working on an existing database. We have four letters to be included in the database functionality.
For example

Dear Mr/Ms "XXXXX(Name of Person)"

Congratulations on the successful completion of your project "XXXXX(ProjectN ame).....It was pleasure working with you and and the "XXXXXX(Supervi sorName)....etc


Sincerely,

John Doe
Manager

I created a report and add this letter in a textbox.(is it right way to do it?)
How do I insert the name of the person, Projectname and supervisor name automatically?

Please help me I have come across such thing for the first time.

[Delerna]

There are many many many ways to achieve what you describe.
Many solutions are based around a form where you select the record to be printed.
There is then a Query that is filtered by the selections on your form.
Finally the report that prints is based off the query so the report can obtain the info you mention (Name of person,Project Name and supervisor name) into bound controls such as text boxes.

There is a button on the form that prints that report from the onclick event.

I have made some very general statements that describe the process.
You will need to provide more detail into what you are using/doing.

[Delerna]

Another possibility is if the info you require is on an open form when the report prints, you can pull the information into the report straight off the form.

All methods require you to provide some way for the user to select a particular record for printing in a report and also providing some way for the report to access that selected record

[jinalpatel]

I think I can use the second answer. I have a bound form which has three textboxes (Name of person,Project Name and supervisor name) .
And I have a command button which opens a report that has all the writing with Name of person,Project Name and supervisor name .
How do I actually supply that textbox values to that report? I put a textbox instead of "XXXXX" in the letter. But that doen't work. It shows # error instead of showing actual letter.

[jinalpatel]

I created a label and put all the letter writing into it. Instead of XXXXX, I put a textbox which has controlsource = [forms]![frmMain]![txtProjectName].

Now it shows the exact record from the main form but it is showing 11 same records. I mean 11 letters with same project name, etc..

One fact is. my main table (to which my report and main form is bound) has 11 records in it.

How to fix it?
Thanks!!

[ChipR]

You want your report not to be bound to a table and just show the letter for the record on the form when you click the command button right?

[jinalpatel]

OKAY!!
my bad!! It was a dumb mistake. that report was bound to that table. that is why it was showing 11 records ..and all same..
weired but true..
!!
Thank you all for helping out.