Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 16th, 2005, 06:03 AM
Registered User
 
Join Date: May 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default subform data in report

HI
I am creating a report from a current record which has sub forms in the main form. Please could you give me the access path i have to put in the report to allow the data to be accessed from the subform
Thanks in advance
Karl:)
 
Old May 16th, 2005, 06:41 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Exhibitor,
I think first of all we should translate ur question to an access language.
Are u saying that u are creating a report from a form with subform ? Ok, what
would u mean saying: "allow the data to be accessed from the subform"?
Would that mean u want the data on the subform to be on the report ? Ok, if
that is the case try using the report wizard.
Rgds Penta

 
Old May 16th, 2005, 08:47 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hi,

   You will probably need to create a query that duplicates the structure of the form/subform. Then use the report wizard. Alternatively, use the report wizard to do the whole thing, but this can be problematic.

   You can also pass parameters to your underlying query from the form/subform.

HTH


mmcdonal
 
Old May 16th, 2005, 10:14 AM
Registered User
 
Join Date: May 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have found on the microsoft web site Article ID 209099

How to refer to a control on a subform or subreport in access 2000

it shows this code

forms![main form name]![subform control name].form![control name]

when i put this in a report it puts [] around the word forms and form.

but it only producers a #name? on the report

can any one help?
 
Old May 16th, 2005, 12:19 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

See my topic "reaching a subform through code". I've escaped the problem by
having the form and subform related by a wizard form link solution. So u will
call form and subform as forms. Although Randall suggested a solution to the
first problem which i'll have to try further.
Hope that help,
Penta:)






Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigating data in a subform Bob Pierce Access VBA 2 February 1st, 2007 10:58 AM
count data from subform Vince_421 Access 1 May 27th, 2006 11:51 AM
Subform not displaying data hikinfool Access 8 February 24th, 2006 06:11 PM
Subform on many to many data aware Access 14 August 12th, 2005 02:36 AM
Display data in a subform marcin2k Access VBA 1 March 1st, 2005 04:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.