Selecting Data from subform

muppetmad

Registered User.
Local time
Today, 22:46
Joined
Sep 29, 2003
Messages
42
Each record in the database has a subform (one to many relationship) with multiple records. When the user clicks on a record in the subform I want the information from the subform and from the mainform to go into a Word document. I am able to pull the data from the main form but not from the sub form. Any suggestions would be appreciated. Below is an example of what I am using to get the data out of the main form for the bookmark in Word called "ClientName".

.ActiveDocument.Bookmarks("ClientName").Select
.Selection.Text = (CStr(Forms!frmClients!txtFName) & " " & (Forms!frmClients!txtLName))
 
Thanks, I tried using the example but i still get error 2465 Application defines or object defines error. The subform is a continuous form is there something I need to be doing to cause it to use the selected record.

Correction. That error was caused by a naming problem.

Thanks for all the help!
 
Last edited:

Users who are viewing this thread

Back
Top Bottom