Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Unanswered: combo box results which are dependant on a combo box

    i've done this before i just can't remember how

    i've got the combo box ProdGrp

    and a combo box Prod

    Prod's SQL = Selet [ProdCode], [prodName] From [Products] Where [Group] = [forms]![SelProd]![ProdGrp]

    what combination of refresh and requery do i need to do to update the results every time the value in ProdGrp changes
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  2. #2
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    In the after Update of the ProdGrp, u need to add
    Me!NameOf Combo2.Requery

    This will requery the 2nd combo after a selection is made in combo1.

    I hope this help.

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    ah ha, i found my problem i wasn't reseting the value in the second combo, thanks for the help
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  4. #4
    Join Date
    Nov 2002
    Location
    Melbourne
    Posts
    92
    Glad you've solved it!

Posting Permissions

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