Welcome to SPN

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

Sign Up Now!

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. 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. 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...

    >
     

Share This Page