Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2006
    Posts
    19

    Unanswered: Help with Access

    I'm trying to make it so that when I choose a category from a combo box, then the subform shows the records from only said category. I want to know if this is possible, and how can it be done. Here is a pic of what I'm trying to do.

    Thanks in advance!

    http://img315.imageshack.us/img315/9752/screenxg8.jpg

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    Link the subform to the Combox

    Link Child Fields
    Link Master Fields

    in the Properiesd of the Subform

    I always make the combo box name the same name as what i'm linking to in the Subform then its just a copy paste
    Last edited by myle; 09-07-06 at 16:26.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Sep 2006
    Posts
    19
    Quote Originally Posted by myle
    Link the subform to the Combox

    Link Child Fields
    Link Master Fields
    How can I do this?

  4. #4
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Link Child and Master fields are properties of the subform. Select the subform in design view, open the properties tool bar and it's there. Be careful not to actually enter the sub form when you click on it.

    tc

  5. #5
    Join Date
    Sep 2006
    Posts
    19
    Quote Originally Posted by tcace
    Link Child and Master fields are properties of the subform. Select the subform in design view, open the properties tool bar and it's there. Be careful not to actually enter the sub form when you click on it.

    tc
    Can you please explain me where can I find this? I can't find the property child and master fields in the subform properties.

  6. #6
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    See attached.
    Attached Thumbnails Attached Thumbnails Sprite7.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •