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

Subforms to filtered reports

P: 28
Hello,

My database is almost finished! (Yippee). Could you please help me with the following:

My main form [frm_Treatments] has been setup so that when a button is clicked a report is generated for the active record. To do this I put the following code in the reports filter field:

([treatment no]=[Forms]![frm_Treatments]![treatment no])

I have now altered the form to incorporate a subform [subform_Treatment Payments] and would like to incorporate the fields in this form so they appear in my report.

Is there a simple way of doing this?

Access 2002.

Please remember that I'm a Noobie.

...sorry for posting in wrong section... I couldn't delete after I realised my mistake.
Oct 10 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
Just check:
http://www.mvps.org/access/forms/frm0031.htm
to see that for a subform you need:
forms!formname"subformname.form!variablename

Many fine other info on that site, take a look :-)

Nic;o)
Oct 10 '07 #2

P: 28
Thanks Nic,

That is a valuable resource.
Oct 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.