Results 1 to 7 of 7
  1. #1
    cjohnson is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    6

    can't put 2 subforms on a main form

    I am new to access (2nd week!!!) and have muddled my way through to this point with dummies guide and forum help!!! but am stuck again!
    I've created an inventory database for work and am trying to add a second subform to my form but it doesn't seem to hide the data when I move to adding a new item.
    Click image for larger version. 

Name:	test form.jpg 
Views:	23 
Size:	50.9 KB 
ID:	28448Click image for larger version. 

Name:	maintenance.png 
Views:	23 
Size:	24.1 KB 
ID:	28449Click image for larger version. 

Name:	test form2.png 
Views:	23 
Size:	21.4 KB 
ID:	28450Click image for larger version. 

Name:	maintenance2.png 
Views:	23 
Size:	23.3 KB 
ID:	28451
    as you can see the valuations have gone but the maintenance is still there.

    this is what the relationship bit looks like


    Click image for larger version. 

Name:	relationship.png 
Views:	23 
Size:	12.3 KB 
ID:	28452
    I have tried to follow what forums have said but get quite lost in the computer speak.....

    Thank you for your help!!!(again!!!)

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,684
    Did you set the Master/Child Links properties of the subform container control?
    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.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,596

  4. #4
    cjohnson is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    6

    Thank you

    trouble is this is such a small part of my job would just like it to get set up so that I can move onto the next item on the list - understand muddling through is not the best option but probably won't use database after this project again so don't really have the time to follow all instructions it's doing what I want to this point just need help with this final but.

    thank you for your help though.

    Quote Originally Posted by orange View Post
    cj,
    Muddling is not a good strategy.
    Look through the videos and work through the tutorials in this link.
    2 weeks of Access without some database will lead to frustration.

    Good luck

  5. #5
    cjohnson is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    6
    thank you - no I haven't looked at Master/Child link properties will have to work out where to look for that.

    thank you for your help

  6. #6
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    2,915
    In Form Design View of the Main Form

    1. Select the Subform Control
    2. Go to the Properties Pane
    3. Make sure the PP 'Selection type' (top, left of box) says Subform/Subreport
    4. Click on Data

    Set the Master/Child link properties to the Fields that are the link between the two Forms.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,596
    If you have 26 minutes, here is a video on Stock Control. It also has a link to download the database.

    Good luck.

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

Similar Threads

  1. Replies: 11
    Last Post: 05-13-2015, 11:10 PM
  2. Adding subforms on a main form
    By ludovic_44 in forum Forms
    Replies: 14
    Last Post: 04-28-2014, 09:45 AM
  3. Multiple subforms to one main form
    By mick3911 in forum Forms
    Replies: 8
    Last Post: 02-25-2013, 09:40 PM
  4. Replies: 1
    Last Post: 08-02-2012, 02:11 PM
  5. Replies: 0
    Last Post: 12-16-2008, 07:49 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
  •  
Tech Forums: Microsoft Office Forums