Results 1 to 2 of 2
  1. #1
    agmorgan is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    1

    subforms

    Hi. I am a new ish user of Access, I have used it for simple databases in the past. However, I want to get a bit clever and I am starting to drown.

    I have a number of tables with core information / lists. In my case this is types of material, Flat bar, angle bar round bar as an example. In another table I have a list of these materials broken down in to sizes and cost. i.e Flat bar size 10x4 $6, Flat bar size 10x6 $8 . Clearly this particular list is very long.

    I want to create an order sheet. therfore in a form I choose the material and in a subform a list of the avalable products comes up. Which is great.

    BUT I want to save this all in a new list and for the life of me I don't get it. My understanding is that if I make an alteration in this form I am clearly altering the core data list.. Not recording it in a seperate list.



    I have set up a seperate list but can see no way of linking this great looking form with the area I want to record the data.

    The microsoft book I am working through show me how to do all the little elements but no where does it show how the record is saved. Clearly I am having a mind warp Can anyone point me in the right direction.

    Andy

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    Here is some info on bound forms. See if it helps.
    Bound forms are tied to an underlying tablr or query.
    http://www.dhdurso.org/articles/ms-access-forms.html

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

Similar Threads

  1. Subforms
    By fwillia in forum Access
    Replies: 2
    Last Post: 09-24-2010, 08:03 AM
  2. subforms
    By thewabit in forum Forms
    Replies: 6
    Last Post: 02-01-2010, 09:03 PM
  3. Help with subforms
    By chocpoc in forum Forms
    Replies: 0
    Last Post: 05-20-2009, 11:50 PM
  4. SubForms
    By duckie10 in forum Access
    Replies: 4
    Last Post: 05-17-2009, 07:15 PM
  5. Subforms
    By henryclay in forum Access
    Replies: 0
    Last Post: 07-24-2007, 07:51 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