Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013

    Unanswered: Print/Create Report from Subform


    I am an MS Access 2010 novice and helping put together a small database for inventory managemen. I have come across a small problem that despite several trawls through online forums I'm still stumped. Any 'steers in the right direction' would be most welcome...

    I have a plain form that I have added in a subform (table) to enable multiple entries to be made on the screen. What I would like to do is print the completed page (form and subform) which can then be passed to whoever took away the items.

    I understand that forms/subforms are not designed for printing but I cant figure out how to create a report without it creating the entire content of the datasheet and not just the subform content.



  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Why not create a report/subreport combination that use the same data sources as the form and subform? Then you can pass the form's key value to the report in the OpenArgs argument, and the report will print out what the form is displaying.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    think you can save form layouts as a report
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts