Welcome to SPN

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

Sign Up Now!

select row and display information

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

  1. Kirt84

    Kirt84
    Expand Collapse
    Guest

    I am still a novice user of Access and need some help. I have a Database that
    controls the stock levels within my company. I have created various sections
    to display where current products are within the process. This is displayed
    using a form and the information is displayed on a subform so that the grand
    total of the stock can be displayed.

    I would like to have the function to select a row on the subform and by
    double clicking - open another form (input form) displaying that record. Is
    this possible?

    --
    Thank you for your help
     
  2. Loading...


  3. Larry Daugherty

    Larry Daugherty
    Expand Collapse
    Guest

    You can get that functionality by running your well crafted sub
    procedure ...

    To start, design and name the form you're going to open so that there
    will really be something for your new code to open.

    Then ...

    To start, I recommend that you add a command button to your subform
    that will show on each row titled something like "Show this record".
    You'll change things more to your taste after you get it to work.

    In the Click Event of that command button put your code using

    DoCmd.OpenForm()

    Usually the biggest hurdle is learning how to refer to subforms.
    There is a good explanation on www.mvps.org/access

    Another thing I recommend is that you open the new form in Dialog mode
    so that it will keep the user from fiddling with other parts of your
    application while that form is open.

    HTH
    --
    -Larry-
    --

    "Kirt84" <Kirt84@discussions.microsoft.com> wrote in message
    news:4CCAD188-CF4E-42C2-A3EC-A7375354323E@microsoft.com...
    > I am still a novice user of Access and need some help. I have a

    Database that
    > controls the stock levels within my company. I have created various

    sections
    > to display where current products are within the process. This is

    displayed
    > using a form and the information is displayed on a subform so that

    the grand
    > total of the stock can be displayed.
    >
    > I would like to have the function to select a row on the subform and

    by
    > double clicking - open another form (input form) displaying that

    record. Is
    > this possible?
    >
    > --
    > Thank you for your help
     

Share This Page