Results 1 to 2 of 2
  1. #1
    Rynorem23 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2013
    Posts
    2

    Form to report with data

    I created a form (Access 2003) that has info from Combo boxes where the information is selected. I need to be able to email that form with it's selected data to employees. If I can make it into a report and then send it that is fine. But I don't know how to make a form with the data show up in a report either. For example I have created a form where the person's name can be chosen from a drop down list. If I try to save that form all the info is across the top of the saved document and doesn't look like the form at all. I need to be able to send that form with data electronically and if it can be made into a report that looks like the form with selected data, that would be awesome.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Build a form that has the same recordsource as form. Apply same filter to report. Review http://datapigtechnologies.com/flash...mtoreport.html

    What format is the 'saved document'?

    What code are you using for the email procedure?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-10-2012, 03:44 AM
  2. Report based of filtered data from a form
    By Fabdav in forum Reports
    Replies: 1
    Last Post: 09-15-2011, 05:28 AM
  3. form data transfer to a report
    By poppinggizmo in forum Forms
    Replies: 1
    Last Post: 06-06-2010, 09:00 PM
  4. Export form data to report
    By rev_ollie in forum Forms
    Replies: 3
    Last Post: 04-22-2010, 05:24 AM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums