GETTING DATA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I have a form that opens up a report, and pulls certain info from it,
such as name, address etc. I have recently added a subform to this main form
and I want the report to be able to pull info from that too. Thanks
 
Karl,
Assuming that the Main form and Sub form are related via a relationship, (ex. CustID).
For example, a Main is based on Customers, and a Sub based on OrderItems.
In the report, add and relate both those tables into the query behind the report.
The ONE Customer info in the report Header/s, and the MANY OrderItems info in the
detail section.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
There are 10 types of people in the world.
Those who understand binary, and those who don't.
 
Back
Top