Welcome to SPN

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

Sign Up Now!

Current record not displaying properly

Discussion in 'Information Technology' started by alaskahawk, Nov 17, 2005.

  1. alaskahawk

    alaskahawk
    Expand Collapse
    Guest

    I have a datasheet based on a query and when I double click a record I want
    that one displayed in another form. Access picks the correct current record
    number but the data displayed in the other form is different than that one I
    selected in the datasheet. Any ideas why? I have removed all filters/sorts
    to speak of.
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 16 Nov 2005 10:47:47 -0800, "alaskahawk"
    <alaskahawk@discussions.microsoft.com> wrote:

    >I have a datasheet based on a query and when I double click a record I want
    >that one displayed in another form. Access picks the correct current record
    >number but the data displayed in the other form is different than that one I
    >selected in the datasheet. Any ideas why? I have removed all filters/sorts
    >to speak of.


    I have no idea. What are the Recordsources of the two forms? What's
    the code in your Click event?

    John W. Vinson[MVP]
     
  4. alaskahawk

    alaskahawk
    Expand Collapse
    Guest

    Nevermind, the sort order has to be exact in both the datasheet AND the form
    of which I was trying to open. To do this successfully, I had to sort on two
    distinctive fields, userid and ticket number...thanks!

    "alaskahawk" wrote:

    > I have a datasheet based on a query and when I double click a record I want
    > that one displayed in another form. Access picks the correct current record
    > number but the data displayed in the other form is different than that one I
    > selected in the datasheet. Any ideas why? I have removed all filters/sorts
    > to speak of.
     

Share This Page