Results 1 to 6 of 6
  1. #1
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Oct 2010
    Posts
    55

    subform

    I have a main form Contact Details and a subform. I am trying to link the subform to the primary key which is ID but cannot field the option in properties when clicking on the subform. I cannot find Child Link Master. The subform I created is a command button and when you click on it opens up. I am not sure why I cannot find the links field when clicking on properties in the subform. My ID field is set as a primary key.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Open the main form in design view.
    Click on the outline of the subform. This can be tricky if you have A2016
    What you are actually doing is clicking on the container that holds the subform and not the subform itself.

    In the properties sheet, you should now see master and child entries ready for you to populate.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  3. #3
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    55
    Thank you for quick response. I think my problem is I created a new form and added it to the main form as an command button. I want to be able to click on the text and open up the form and have the data link back to the main form. If I created a subform using the wizard and I am not able to click on the field and have the form come up.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    I think my problem is I created a new form and added it to the main form as an command button.
    I assumed this was a typo in the original post.

    If its another form within the main form, then it's a subform but you shouldn't use a button click to make it visible

    If you mean that your button code opens a completely separate form, then its not a subform.
    If you are opening a completely separate form, you can filter it so it opens to the same or a related record
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  5. #5
    Alaska1 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Oct 2010
    Posts
    55
    Thank you. It is not a subform. It is a form. Is the option to filter on related or same record in properties?

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,127
    Look up DoCmd.OpenForm in access help

    You will need code something like this
    Code:
    DoCmd.OpenForm "MyNewFormName", , ,"FieldName = 'some value'"
    For example,
    [
    Code:
    DoCmd.OpenForm "Employees", , ,"LastName = Smith'"
    You could also try watching Access videos on You Tube.
    For example: https://www.youtube.com/watch?v=RILqSTAAQpM may be helpful
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Replies: 3
    Last Post: 12-06-2018, 03:27 PM
  2. Replies: 2
    Last Post: 01-21-2018, 09:19 PM
  3. Replies: 3
    Last Post: 06-29-2017, 03:02 PM
  4. Replies: 1
    Last Post: 12-05-2016, 02:23 PM
  5. Replies: 6
    Last Post: 05-05-2012, 08:43 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