Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Posts
    2

    Question Unanswered: Filter combo box values based on another

    How do I filter the values shown (listed) in a combo box on a form based on the selected value in another combo box in that same form? Example: ProductType (Pesticide, Fertilizer, ..) and ProductName (Prod1-Pesticide, Prod2-Pesticide, Prod3-Fertilizer, Prod4-Fertilizer, etc.)

    Thanks,
    FarmerJoe

  2. #2
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109

    let Access do it for yourself

    I suggest you let Access take care of that, just link your first ComboBox (ProductID) to the ID field, and link your second Combox to your ProductName field. Since they are linked to the database, they will automatically change alone. You may also use SubForm to link to others tables

    JefB

Posting Permissions

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