Tricky one potentially?

[Zunn]

I have a form which is linked to a main client eg. (father) and a subform which displays the children's details. The number of children in each family can vary.

Could I populate a Word document with the full family details (client and all the children)?

Y.
ps. also I would like to know how I could output a carriage return?

 

[danvlas]

Create a report and output it as rtf...
I guess Automation with Word is a long shot for now...

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[LonnieJohnson]

This is assuming you have a button that you click on the main form to send info to the word document.



Dim strDocInfo as String
strDocInfo = Me.MyFieldName & vbNewLine _
& Me![MySubformName].Form![SubformFieldName]

This will get the data into a variable so that you can put it in the word document. It's just a rough picture but it gives you the referencing of parent fields, child fields and the new line.

Hope it helps.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!