By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

Merge to MS Word

P: n/a
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
Jan 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Jan 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.