Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2008
    Suffolk, United Kingdom
    Thanked 0 Times in 0 Posts

    Limit selection in a combo-box based on another (2003)

    Hi I would like to know how to limited the available options in a combo box based on the selection of another combo box, but the first combo box already filters the form for me.

    I have five villages and each village has a selection of customers. If I select 'village b' in combo box 'cmbvillagefilter' the form applies a filter to all customers whos village is 'village b' I would like the second combo box which is called 'cmbSelectCustomer' to only display the customers that match the selection from 'cmbvillagefilter' so I can easily find a specific customer.

    I would like the second combo to use the information, 'CRN' & 'FirstName' & 'Last Name' from the main form.

    Thank you experts!
    Gerbil (AKA Kevin)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Limit selection in a combo-box based on another (2003)

    See How to synchronize two combo boxes on a form in Access 2002 or in Access 2003. There are also several examples of cascading combo boxes in this forum, e.g. <post#=132,255>post 132,255</post#>.

Posting Permissions

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