Merge to MS Word

[ILoveAccess via AccessMonster.com]

I have the following forms:

frmLeads (main form)
frmHistory (subform of frmLeads)

***************************

I want to merge the record to MS Word and to look similar to below:

Mr. John Doe
ABC Company
1652 West Virginia Rd.
Boise, ID 83706

1/2/06 - Requested Info from us
1/3/06 - Called ABC Company and left msg
1/6/06 - Contacted, wants a quote

***********

The problem is, a record is printed for each record in frmHistory. EXAMPLE:

ABC Company
1/2/06 - Requested Info from us

ABC Company
1/3/06 - Called ABC Company and left msg

ABC Company
1/6/06 - Contacted, wants a quote

************

Do you know how I can make it work how I need it to?

--
Message posted via http://www.accessmonster.com

[Mike Preston]

On Thu, 05 Jan 2006 18:33:27 GMT, "ILoveAccess via AccessMonster.com"
<u10461@uwe> wrote:

I have the following forms:

frmLeads (main form)
frmHistory (subform of frmLeads)

***************************

I want to merge the record to MS Word and to look similar to below:

Mr. John Doe
ABC Company
1652 West Virginia Rd.
Boise, ID 83706

1/2/06 - Requested Info from us
1/3/06 - Called ABC Company and left msg
1/6/06 - Contacted, wants a quote

***********

The problem is, a record is printed for each record in frmHistory. EXAMPLE:

ABC Company
1/2/06 - Requested Info from us

ABC Company
1/3/06 - Called ABC Company and left msg

ABC Company
1/6/06 - Contacted, wants a quote

************

Do you know how I can make it work how I need it to?

Yes.

Oh, you also want me to share that information, huh? Well, ok.

Look in Word help for NextRecord. It is a fieldcode that tells word
to get further information from the, well, Next Record, rather than
loading another instance of the main form for processing.

mike