Results 1 to 3 of 3
  1. #1
    Gaccesses is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    2

    New Line (New Order) on same form

    How can I create an order sheet?



    For example:

    Person A...

    Person A orders a pencil, a laptop, a notepad, and twizzlers

    How create a form where All of person A 's items can be listed on one form by clicking an additional order button?

    I also wanted for the table to look like this:

    Perseon A Pencil
    Person A Laptop
    Person A notepad
    Person A twizzlers


    Is this possible? HELLP!

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    You should research 'Master Detail Form'.
    This is a scenario where there is a Master Form [which would display the Person, for instance] and the Detail Form, which would display everything that the Person ordered.

    See if this microsoft page helps you:
    http://office.microsoft.com/en-us/ac...010098674.aspx

  3. #3
    Gaccesses is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Jul 2012
    Posts
    2
    Quote Originally Posted by Robeen View Post
    You should research 'Master Detail Form'.
    This is a scenario where there is a Master Form [which would display the Person, for instance] and the Detail Form, which would display everything that the Person ordered.

    See if this microsoft page helps you:
    http://office.microsoft.com/en-us/ac...010098674.aspx
    Thanks, will try

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

Similar Threads

  1. Replies: 7
    Last Post: 04-11-2011, 03:58 PM
  2. Select line from a form for a report
    By drf3794 in forum Access
    Replies: 3
    Last Post: 03-17-2011, 11:01 AM
  3. How to do line by line compare of VB code?
    By Buakaw in forum Access
    Replies: 2
    Last Post: 02-14-2011, 11:46 PM
  4. Adding line numbers to a purchase order report
    By jordanturner in forum Reports
    Replies: 1
    Last Post: 12-08-2010, 08:25 AM
  5. Replies: 1
    Last Post: 11-07-2010, 11:04 AM

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