Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Synchronized Combo Boxes

Discussion in 'Information Technology' started by Christian >, Jul 28, 2006.

  1. Christian >

    Christian >
    Expand Collapse
    Guest

    How can I get my combo boxes that are based on a SQL statement to requiry
    when I navigate to the record.

    I have several Combo Boxes that are synchronized to one combo box. When
    data is entered in the main combo box, the other boxes are then limited.
    This works fine.

    The problem is that when the user navigates to another existing record those
    same combo boxes aren't queried to the current record, but the previous one
    because no new data was entered...
     
  2. OP
    Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    Requery each combo box control in the Form's Current event procedure:

    Me.YourFirstCombo.Requery
    Me.YourSecondCombo.Requery
    Me.YourThirdCombo.Requery

    Incidentally you might like to take a look at my demo of correlated combo
    boxes at:


    http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=23626&webtag=ws-msdevapps


    Ken Sheridan
    Stafford, England

    "Christian ><>" wrote:

    > How can I get my combo boxes that are based on a SQL statement to requiry
    > when I navigate to the record.
    >
    > I have several Combo Boxes that are synchronized to one combo box. When
    > data is entered in the main combo box, the other boxes are then limited.
    > This works fine.
    >
    > The problem is that when the user navigates to another existing record those
    > same combo boxes aren't queried to the current record, but the previous one
    > because no new data was entered...
     
  3. OP
    Christian >

    Christian >
    Expand Collapse
    Guest

    Awesome, thanks!

    "Ken Sheridan" wrote:

    > Requery each combo box control in the Form's Current event procedure:
    >
    > Me.YourFirstCombo.Requery
    > Me.YourSecondCombo.Requery
    > Me.YourThirdCombo.Requery
    >
    > Incidentally you might like to take a look at my demo of correlated combo
    > boxes at:
    >
    >
    > http://community.netscape.com/n/pfx...yMessages&tsn=1&tid=23626&webtag=ws-msdevapps
    >
    >
    > Ken Sheridan
    > Stafford, England
    >
    > "Christian ><>" wrote:
    >
    > > How can I get my combo boxes that are based on a SQL statement to requiry
    > > when I navigate to the record.
    > >
    > > I have several Combo Boxes that are synchronized to one combo box. When
    > > data is entered in the main combo box, the other boxes are then limited.
    > > This works fine.
    > >
    > > The problem is that when the user navigates to another existing record those
    > > same combo boxes aren't queried to the current record, but the previous one
    > > because no new data was entered...

    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page