Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Interdependent Combo Boxes (2000 - can be higher)

    Part of the data for a Master Record draws from 2 Combo Boxes. Most of the time, new entries are needed in at least one of the Tables underlying the Combo Boxes - and these are dealt with by coding the Not In List Event.

    Is it possible to link entries so that - on recurrence - the second Combo Box is populated from the first?

    Combo Box 1 is in yy-mm-dd format - held as a String.
    Combo Box 2 is a location.

    Only one location is ever set for a particular yy-mm-dd. There can, however, be more than one Record for that particular yy-mm-dd. At the moment, I have been trying having a location field in the Table that holds the yy-mm-dd entries. If, however, that location field's Required value is set to Yes, the code for the yy-mm-dd Not In List Event no longer overrides the Not In List error.

    It would seem that one needs something that runs on the "In List" Event - which, AFAIK, does not exist!
    Gre

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interdependent Combo Boxes (2000 - can be higher)

    You can use the After Update event of combo box 1 to reset the row source of combo box 2 according combo box 1 and do a requery of combo box 2.
    You can have a look at <A target="_blank" HREF="http://rogersaccesslibrary.com/download3.asp?SampleName=CascadingComboBoxes.mdb"> Roger
    Francois

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Interdependent Combo Boxes (2000 - can be high

    Merci bien. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

    For the record: a reference to the relevant "Microsoft ActiveX Data Objects Library" is required.
    Gre

Posting Permissions

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