Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sync Combos (2000)

    Hi, I have two synchronised combos, whatever is sleected in A determines what can be selected in B. These two populate corresponding fields on a many form say field 1 and 2. I need a way of maintaining integrity when data is amended, for instance in box A number 1 will restrict box B to letters X or Y or Z, number 2 in box A will restrict to E or F or G. There is currently no enforcement to prevent a user who has perhaps entered a record of 1 and X then changing the combo box A to 2 and then being giving the options of E F or G in box 2, clicking in field 2 and have that updated with say G, the record then becomes 1 and G, i.e. incompatable as 1 and G don't go. What code could I use the force compatability.

    Thanks Darren.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sync Combos (2000)

    Add a line to the After Update event procedure of A to set the value of B to Null.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sync Combos (2000)

    Thanks Hans.

    Darren.

Posting Permissions

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