Results 1 to 8 of 8
  1. #1
    bpalmereng is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    7

    Filter Subform

    Below is a picture of a form I'm trying to build, Im trying to get the subform to filter based on the combo box. The table is a Query table that needs to filter transactions based on an employee who's name is chosen in the combo box. If anyone could help with this I would greatly appreciate it. I have no clue how to get this to work. I've tried looking at guides but they are not clear and they don't explain well enough for me to understand. The combo box source control is also Employee from the query table if that helps..




    Click image for larger version. 

Name:	Access Issue.JPG 
Views:	13 
Size:	279.8 KB 
ID:	30043

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Link the subform to the combobox - the name of the combobox will be the Link Master Field (this must be the first column in the query of the combobox) and the corresponding name in the subform will be the Link Child Field.

  3. #3
    bpalmereng is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    7
    After trying what you said. It says can't build a link between unbound forms

  4. #4
    Join Date
    Apr 2017
    Posts
    1,673
    There is a difference sometimes between what MS thinks his pograms do, and reality

    Don't use wizard - open subforms properties and edit LinkMasterField and LinkChildField directly.
    Some programmers advice not to use direct link to parent datasource at all - they say that even when there is the field in parent form to link, better create an unbound control on parent form and link the subform to this unbound control.

  5. #5
    bpalmereng is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    7
    Still telling me Cant build link between unbound forms. even after taking your advise.

  6. #6
    bpalmereng is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    7
    I cant change the Link Master Field, or Child field. Keeps telling me "Can't Build link between unbound forms" If anyone else has some advise I'm open ears. At the moment I'm completely lost. Both are empty currently.

    Click image for larger version. 

Name:	access issue2.jpg 
Views:	11 
Size:	76.8 KB 
ID:	30046

  7. #7
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Type in the values. As previously stated, do not use the wizard.

  8. #8
    bpalmereng is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    7
    Thank you that fixed it. Appreciate it.

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

Similar Threads

  1. Replies: 1
    Last Post: 12-05-2016, 02:23 PM
  2. Replies: 13
    Last Post: 03-09-2014, 02:11 AM
  3. Replies: 1
    Last Post: 08-16-2012, 01:51 PM
  4. Replies: 6
    Last Post: 05-05-2012, 08:43 AM
  5. Pass Subform filter to subform in report
    By camftm in forum Programming
    Replies: 16
    Last Post: 07-19-2011, 07:12 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